Thread: Text Extraction
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default 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