This was exactly what I was looking for.
Thanks
Michael
"Jason Lepack" wrote in message
s.com...
I put your two tests in Cells A1 and A2.
Paste this into a column and fill down:
=MID(A1,FIND("(",A1)+1,FIND(")",A1)-FIND("(",A1)-1)
Cheers,
Jason Lepack
Michael wrote:
I have a list in Excel from A1:A100 with names like the ones mentioned
below:
Michelle Fooo )
Myhaass Smith )
I want to parse them using string functions to the following format
Any ideas how to do this using a formula?
Thanks in advance
Michael