Need to separate multiple numbers in one cell
 

I have multiple number in one cell and i need to somehow put each number into one separate cell for each number:

I have :
column A
row1 2 5 8 10

I want:
column B column C column D column E
row1 2 5 8 10


How do I do it on Excel 2007?

thanks

EggHeadCafe - Software Developer Portal of Choice
Map Stored Procedure Output To Class Properties
http://www.eggheadcafe.com/tutorials...dure-outp.aspx

Need to separate multiple numbers in one cell
 

Hi,

Use Data Text to columns and specify the delimiter as space

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"sierra spiegel" wrote in message
...
I have multiple number in one cell and i need to somehow put each number
into one separate cell for each number:

I have :
column A
row1 2 5 8 10

I want:
column B column C column D column E
row1 2 5 8 10


How do I do it on Excel 2007?

thanks

EggHeadCafe - Software Developer Portal of Choice
Map Stored Procedure Output To Class Properties
http://www.eggheadcafe.com/tutorials...dure-outp.aspx

separating multiples digit in a cell into individual cell
 

And how do you do data text?



Ashish Mathur wrote:

Hi,Use Data Text to columns and specify the delimiter as
17-Nov-09

Hi,

Use Data Text to columns and specify the delimiter as space

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"sierra spiegel" wrote in message

Previous Posts In This Thread:

EggHeadCafe - Software Developer Portal of Choice
Essential ASP.NET 2.0 [Addison-Wesley]
http://www.eggheadcafe.com/tutorials...net-20-ad.aspx

separating multiples digit in a cell into individual cell
 

Hi,

Go to the Data menu and in the, under Data Tools you will see Text to
columns

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"sierra spiegel" wrote in message
...
And how do you do data text?



Ashish Mathur wrote:

Hi,Use Data Text to columns and specify the delimiter as
17-Nov-09

Hi,

Use Data Text to columns and specify the delimiter as space

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"sierra spiegel" wrote in message

Previous Posts In This Thread:

EggHeadCafe - Software Developer Portal of Choice
Essential ASP.NET 2.0 [Addison-Wesley]
http://www.eggheadcafe.com/tutorials...net-20-ad.aspx