Need to separate multiple numbers in one cell

[sierra spiegel]

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/tutorial...e-46847fa770ef/map-stored-procedure-outp.aspx

 

[Ashish Mathur]

Hi,

Use Data > Text to columns and specify the delimiter as space

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

in message
news:[email protected]...

 

[sierra spiegel]

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 spac

-
Regards

Ashish Mathu
Microsoft Excel MV
www.ashishmathur.co

in message

Previous Posts In This Thread:

EggHeadCafe - Software Developer Portal of Choice
Essential ASP.NET 2.0 [Addison-Wesley]
http://www.eggheadcafe.com/tutorial...b4f8-a226ff61219d/essential-aspnet-20-ad.aspx

 

[Ashish Mathur]

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

in message
news:[email protected]...