Thanks everyone! That was so simple.

"Dave Peterson" wrote:

Select the column with the data
Data|Text to columns
Choose delimited
by comma and space
and finish up.

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?

--

Dave Peterson