Text Extraction

  • Thread starter Todd Huttenstine
  • Start date
T

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
 
B

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)
 
T

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)




.
Click to expand...
 
J

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

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)
 
Top