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