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}...
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.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.