Hi,
Please help as this is urgent.
I have the following data in a column. In the report I want to display them only with whatever is before the "-".
A SECOND DAY, INC.-FORMAT 4
A SECOND ADY, INC-VERSION 1
A SECOND DAY,INC.-VERSION 1
CLAIR FOUNDATION - OPTION 1
CLAIR FOUNDATION - OPTION 3
CLAIR FOUNDATION - OPTION 4
C.O.T.I.C. - GRADE 3
RACE D&FS - GRADE 1
PLease help.
Thanks in advance