Opposite of Concatenate function?

[scott-atkinson]

Hi guys,

Could anyone tell me if there is a function in Excel that is the opposite of the Concatenate function?

I have data in a cell that I want to split into separate cells.

If there is not a function, could anybody give me some VB coding that would do the job?

Many Thanks

 

[KenHigg]

Left(), Right() & Mid()

???

 

[Brianwarnock]

Text to columns

I think that you need to be a bit more specific.

Brian