Help in Finding Right Formula

[alish]

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.

 

[John Bundy]

is that all one line? are you just wanting to know for a given line if it
contains the words approved or unapproved?

 

[alish]

John, I have a column A with below info:

(RATIONAL) 4 - STT APPROVED PLUMBER
(additional) 1 - STT UNAPPROVED ELECTRICAL SUPERVISOR
(RATIONAL) 6 - FTT APPROVED ELECTICIAN
(RECOMMENDED) 6 - FTT APPROVED ELECTICIAN

Out of that column I want column B with the below results:
APPROVED PLUMBER
UNAPPROVED ELECTRICAL SUPERVISOR
APPROVED ELECTICIAN
APPROVED ELECTICIAN

Thanks.

 

[Dave Peterson]

Try this...
Select column A and copy it to column B.

Select column B
Then do 3 Edit|Replaces

Edit|Replace
What: UNAPP
with: $$$$$
Replace all

Edit|Replace
what: *APPROVED
with: APPROVED
Replace all

Edit|Replace
what: *$$$$$
with: UNAPP
Replace all