Text Extraction
 

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

Text Extraction
 

=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" wrote in message
...
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

Text Extraction
 

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)

"Todd Huttenstine"
wrote in message
...
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



.

Text Extraction
 

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.


In article ,
"Todd Huttenstine" wrote:

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

Text Extraction
 

Oops, hit send too early:

For a programming solution:

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



In article ,
"Todd Huttenstine" wrote:

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