Trim Multiple items in one column

[Cpreston]

Hi

I have a large spreadsheet that as one column with all the information. I want to spilt the data into different columns before and after a ; appears (example line below). I have looked for Trim commands on google but cannot find anything quite what I am after. Could some assist please. Thanks in advance

26413;RB/8277240792;FSC Mix Credit;RW BC;30x148;5400;223;5.347

 

[Cpreston]

Hi

Its ok managed it I used =TEXTSPLIT(A2,";")

Thanks

 

[Andrzejek]

You could also do - highlight column with your data and:
Data - Data Tools - Text to Columns... - Delimited - Semicolon - Text

---- Andy

"Hmm...they have the internet on computers now"--Homer Simpson