Right, len, find questions

[lildrew112]

I have the following in A1 "Floating/Personal Holiday (FPH)". I want to isolate only "FPH".

I have the following formula: RIGHT(A1,LEN(A1)-FIND(" (",A1)-1) but it's giving me "FPH)". How do I isolate only "FPH"?

Thank you in advance.

 

[Scott T]

Right returns the X number of characters from the end string so you are getting the ).

Try, assuming it is always three characters in the () that you want to return

=MID(A1,SEARCH("(",A1)+1,3)

 

[lildrew112]

Thanks for that but I have other cells with two, three and four between brackets. Any other suggestions?

 

[admiral100]

Hi,

Try this : =MID(A1,SEARCH("(",A1)+1,SEARCH(")",A1)-SEARCH("(",A1)-1)

 

[lildrew112]

That formula worked. Thank you!

 

[Scott Huish]

Since the code is at the end:
=SUBSTITUTE(REPLACE(A1,1,FIND("(",A1&"("),""),")","")