Splitting Text String Into Separate Columns

Hi,

can any please advise me of the formula I need to split a text string into separate columns?

What I have is my CD collection (in column 'A') where current the name of the artist and album is in the same cell separated by a '-' e.g.

Billy Idol - Idol Songs: 11 Of The Best
Billy Joel - The Essential Billy Joel (2CD)
Blancmange - Mange Tout
Blancmange - Second helpings (1990)
Blondie - The Complete Picture (The Very Best)
Blues Brothers - The Blue Brothers Sound


What I require is a formula to split the text so the 'Artist Name' would be in column 'B' and the 'CD Title' in column 'C'

any assistance in this matter would be greatly appreciated

Many thanks in advance

Regards

Rob

Enter formula in B1 and copy across and down

Formula:

Please Login or Register  to view this content.

v	A	B	C
1	Billy Idol - Idol Songs: 11 Of The Best	Billy Idol	Idol Songs: 11 Of The Best
2	Billy Joel - The Essential Billy Joel (2CD)	Billy Joel	The Essential Billy Joel (2CD)
3	Blancmange - Mange Tout	Blancmange	Mange Tout
4	Blancmange - Second helpings (1990)	Blancmange	Second helpings (1990)
5	Blondie - The Complete Picture (The Very Best)	Blondie	The Complete Picture (The Very Best)
6	Blues Brothers - The Blue Brothers Sound	Blues Brothers	The Blue Brothers Sound

AlKey

Excellent !!! Many thanks for you 'very' prompt reply it is exactly what I wanted

Thanks Again

Regards


Rob