With the data in A1 this will do it

=TRIM(LEFT(MID(A1,FIND("-",A1)+1,255),FIND("(",MID(A1,FIND("-",A1)+1,255))-1
))


--

Regards,

Peo Sjoblom

"harvdog" wrote in message
ups.com...
I am trying to SEARCH or FIND a text string in an excel file without
any luck. The character is a hyphen (-) and the excel function (see
about) says it can't see it.

28(Sittin' on) the Dock of the Bay - Otis Redding (1968)

My end result will be to extract the artist from the list of 500 songs.
If anyone has a better approach, I would love to hear it.
Thanks,
HPB