Forum Discussion

Copper Contributor

Jul 04, 2023

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 o...

excel

OliverScheurich

Gold Contributor

Jul 04, 2023

sneh2389

=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.