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
|