Hi ALL,
I always come accross the situation where I need to cut portion of the texts
with different lenths but one or two words in them always. Example:
(RATIONAL) 4 - STT APPROVED PLUMBER, (additional) 1 - STT UNAPPROVED
ELECTRICAL SUPERVISOR, (RATIONAL) 6 - FTT APPROVED ELECTICIAN, (RECOMMENDED)
6 - FTT APPROVED ELECTICIAN. I need to cut all the way upto the words
"APPROVED" and "UNAPPROVED". Since the lengths are different in each phrase,
what formula do I use to perform it? If it was 2 to 3 lines I would do it
manually, but normally it is huge lists. Thanks in advance. Alish.