Thread: Text Extraction
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default 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