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.