Select the column (singular) of data and use Data-Text to columns-Delimited

"Sojo" wrote:

Hello out the

I have the following data:

A
1 shoes, cars
2 jump, skip, hop

I want a formula that will separate the text an put them in inidvidual cells
i.e

A B C D
1 shoes, cars shoes cars
2 jump, skip, hop jump skip Hop

The number of charcters to be copied varies.

Any ideas or is this not possible in excel?