separate text from one cell into 3 or more cells
 

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?

separate text from one cell into 3 or more cells
 

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?

separate text from one cell into 3 or more cells
 

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?

separate text from one cell into 3 or more cells
 

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

separate text from one cell into 3 or more cells
 

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