Try:

Data Text to Columns Check Delimited Next Check Comma OK

If you want the data in columns B,C & D then copt the data from A to B first

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Sojo" wrote in message
...
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?