How To Extract Text Before Or After Dash From Cells?

[fidelito101]

Hello everybody!
I need some help from you, I have a list of (Song - Artist - Album) in A Column and I would like to put the artist in Column B, the song title in column C and the album title in D.

Thanks in advance

A	B	C	D
The Coasters - Charlie Brown - Poison Ivy	The Coasters	Charlie Brown	Poison Ivy
The Impalas - Sorry (I Ran All the Way Home) - Brand New Cadillac: Rock & Roll	The Impalas	Sorry (I Ran All the Way Home)	Brand New Cadillac: Rock & Roll

 

[fidelito101]

Or, alternately, if you want a formula, put this in cell B1 (where I have assumed your first data value is in cell A1) and copy it across to cell D1, then copy cells B1, C1, D1 down to the bottom of your data...

=TRIM(MID(SUBSTITUTE("-"&$A1,"-",REPT(" ",300)),COLUMNS($B:B)*300,300))

Thank you very much for your help.