Text Extraction

[Todd Huttenstine]

Assigned CSS (Adair, Kristen) Total:

Above is a value in a cell. How would I extract the name
Adair, Kristen from it?

Thanks
Todd Huttenstine

 

[Bob Phillips]

=MID(A1,FIND("(",A1)+1,FIND(")",A1)-FIND("(",A1)-1)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Todd Huttenstine]

Thank you

-----Original Message-----
=MID(A1,FIND("(",A1)+1,FIND(")",A1)-FIND("(",A1)-1)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)




.

 

[JE McGimpsey]

One way:

=MID(LEFT(A1,FIND(")",A1)-1),FIND("(",A1)+1,255)

where 255 is just a larger number than the largest number of characters
to be returned.

 

[JE McGimpsey]

Oops, hit send too early:

For a programming solution:

sIn = Range("A1").Text
sName = Mid(Left(sIn, InStr(sIn, ")") - 1), InStr(sIn, "(") + 1, 255)