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

Left(), Right() & Mid()

???

Text to columns

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

Brian