Help in Finding Right Formula
 

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.

Help in Finding Right Formula
 

is that all one line? are you just wanting to know for a given line if it
contains the words approved or unapproved?
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"alish" wrote:

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.

Help in Finding Right Formula
 

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.
"John Bundy" wrote:

is that all one line? are you just wanting to know for a given line if it
contains the words approved or unapproved?
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"alish" wrote:

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.

Help in Finding Right Formula
 

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




alish wrote:

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.
"John Bundy" wrote:

is that all one line? are you just wanting to know for a given line if it
contains the words approved or unapproved?
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"alish" wrote:

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.

--

Dave Peterson