Hi,

This 'probably' works. I say probably because it looks for TT<space and
extracts the characters after that so if this seat of characters is repeated
in the string it could fail. So put this in B1 and drag down

=MID(A1,FIND("TT ",A1,1)+3,LEN(A1))

Mike

"alish" wrote:

Hi ALL,
I need your help in below issue:
I have a column A with below text:

(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

What formula do I use to get the result in column Bt?
Thanks.