Help with splitting cell data with text to columns or using a function

[divster27]

I've got a data set that includes a number of data sets - Artist / Title separated by '/' and then sometimes Format added in ( )
And sometimes more than 1 '/'

eg

Coldplay / Parachutes (1LP)

Del Rey, Lana / Lust for Life (2LP/180g/Gat)

Jones, Norah / Playdate (1LP/RSD)

Joy Division / Substance

Lorde / Melodrama (1LP)

Maximo Park / Nature Always Wins (1LP/Turquoise/MP3)

What i'm trying to do is separate the first data set before the first /
and have the remainder in the second set

So, like this...

Coldplay	Parachutes (1LP)
Del Rey, Lana	Lust for Life (2LP/180g/Gat)
Jones, Norah	Playdate (1LP RSD)
Joy Division	Substance
Lorde	Melodrama (1LP)
Maximo Park	Nature Always Wins (1LP/Turquoise/MP3)

I've been playing around with the Text to Columns functionality, but that doesnt like it when thee's multiple '/'

 

[Fluff]

How about

+Fluff 1.xlsm
	A	B	C
1
2	Coldplay / Parachutes (1LP)	Coldplay	Parachutes (1LP)
3	Del Rey, Lana / Lust for Life (2LP/180g/Gat)	Del Rey, Lana	Lust for Life (2LP/180g/Gat)
4	Jones, Norah / Playdate (1LP/RSD)	Jones, Norah	Playdate (1LP/RSD)
5	Joy Division / Substance	Joy Division	Substance
6	Lorde / Melodrama (1LP)	Lorde	Melodrama (1LP)
7	Maximo Park / Nature Always Wins (1LP/Turquoise/MP3)	Maximo Park	Nature Always Wins (1LP/Turquoise/MP3)
Master

Cell Formulas
Range	Formula
B2:B7	B2	=TRIM(LEFT(A2,FIND("/",A2)-1))
C2:C7	C2	=TRIM(MID(A2,FIND("/",A2)+1,100))

 

[divster27]

thanks Fluff, worked a treat
it's about the worst stocklist i've seen putting sometimes 6 data fields into one..)

 

[Fluff]

You're welcome & thanks for the feedback.