How to break out data combined in a single cell

J

juliejg1

I am trying to pull out numbers from a cell containing multiple numbers
separated by commas. For example, cell C2 contains 2,36,52,81,90,29. I
would like to be able to get the first number is cell D2, the second number
in cell E2, etc. Not sure what functions/formulas to use.
 
M

Mike H

Have a look at:-

Data|Text to columns

Follow the wizard, it's fairly intuative.

Mike
 
M

Max

One way via Data > Text to Columns
Select C2, click Data > Text to Columns > Delimited
In Step 2, check "Other" and enter a comma in the box, click Finish.
 
J

juliejg1

Great! Thanks

Max said:
One way via Data > Text to Columns
Select C2, click Data > Text to Columns > Delimited
In Step 2, check "Other" and enter a comma in the box, click Finish.
Click to expand...
 
G

Gord Dibben

Max

Info only..............there is an optionbox for "comma".

Don't need to enter in "other".


Gord
 
Top