How to break out data combined in a single cell

[Guest]

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.

 

[Guest]

Have a look at:-

Data|Text to columns

Follow the wizard, it's fairly intuative.

Mike

 

[Guest]

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.

 

[Guest]

Great! Thanks

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.

 

[Max]

welcome

 

[Gord Dibben]

Max

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

Don't need to enter in "other".


Gord

 

[Max]

Thanks, Gord.
Admit I missed that option box.