Opposite of Concatenate

[bryant_clare]

I know how to use the concatenate function, but if I have the opposite issue - i.e. lots of text (comma separated) is there a function which will allow me to separate this into different colums easily without anything too manual?

Cheers

 

[BrianB]

menu Data/Text to columns .. ?

 

[bryant_clare]

Cheers!!!