separate text from one cell into 3 or more cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello out there:

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?
 
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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 
Select the column with the data
Data|Text to columns
Choose delimited
by comma and space
and finish up.
 
Back
Top