How to break out data combined in a single cell
 

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.

How to break out data combined in a single cell
 

Have a look at:-

Data|Text to columns

Follow the wizard, it's fairly intuative.

Mike

"juliejg1" wrote:

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.

How to break out data combined in a single cell
 

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
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"juliejg1" wrote:
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.

How to break out data combined in a single cell
 

Great! Thanks

"Max" wrote:

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
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"juliejg1" wrote:
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.

How to break out data combined in a single cell
 

welcome
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"juliejg1" wrote in message
...
Great! Thanks

How to break out data combined in a single cell
 

Max

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

Don't need to enter in "other".


Gord

On Thu, 19 Jul 2007 06:48:01 -0700, Max wrote:

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.

How to break out data combined in a single cell
 

Thanks, Gord.
Admit I missed that option box.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Max

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

Don't need to enter in "other".


Gord