Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by viperstorm

  1. viperstorm

    Formula to remove text after

    Data Displayed: Department - Location Data Wanted: Department I need to remove the space dash space & all text after. Thanks for your help CR85USER & lbass! I wouldnt of figured it out without you. You Rule. This finally worked for me. In case anyone else needs it. left({tblCases.To}...
  2. viperstorm

    Formula to remove text after

    I only want to display Department.
  3. viperstorm

    Formula to remove text after

    My Data looks like this: Department - Location I would like to display Department and remove everything after the first space and dash. So I need to remove everything after " - ". Hope you can help.

Part and Inventory Search

Back
Top