Subroutine to split cells

[jamieb]

Hi,

I have a series of cells in a spreadsheet containing text in the format "texttext, moretext". I want to be able to split these cells, so that the string before the comma and the string after the comma are stored in seperate cells.

My VBA is rubbish, so I can't seem to figure this out. Any help, or pointers to where I can find example of a subroutine doing this, would be much appreciated.

Jamie

[StephenR]

You don't need VBA. Select the cells, Data > Text to Columns > Delimited > tick Comma > Finish.

[jamieb]

That's great, thanks.