On Wed, 25 Jan 2006 18:11:02 -0800, "Steve"
wrote:

I have a list of songs, but the name of the song and artist are all in the
same cell. I'd like to be able to sort by artist.

Is there a formula that I could enter in B1 ,B2 , etc.
that could text everything starting with the 3rd character to the right of
each dash (-) ?
(A1)
Earth Angel - The Penguins
(A2)
El Paso - Marty Robbins

so that the B column result would be
The Penguins
Marty Robbins
Note: The 13 characters in these samples are obviously just a coincidence,
and other cells will have different number of characters.

Thanks,

Steve

Note that if you start with the "3rd character to the right of each dash" your
results would be:

he Penguins
arty Robbins

So I changed it to the 2nd character:

=MID(A1,FIND("-",A1)+2,255)


--ron