Forum Discussion
Extracting text after a specific characters
Hi, I am receiving data in the format String1 String2 String3 (FirstName LastName) (String4) and I would like to extract only FirstName Last Name. My approach so far has been to use LEFT to get rid of everything to the right of ") " marked in bold String1 String2 String3 (FirstName LastName) (String4)
However I am unable to just extract everything to the right of " ( marked in red String1 String2 String3 (FirstName LastName
What should I do?
2 Replies
=MID(A1,FIND("(",A1)+1,FIND(")",A1)-(FIND("(",A1)+1))=RIGHT(LEFT(A1,FIND(")",A1)-1),LEN(LEFT(A1,FIND(")",A1)-1))-FIND("(",LEFT(A1,FIND(")",A1)-1)))With older versions of Excel you can use these formulas.
