separating multiples digit in a cell into individual cell
 

I have a series of number sets. When I copied from the MS Word and pasted them into Excel, all of the numbers in the set are pasted into one cell. I need those numbers to be in an individual cell. How do I do it? I think MS Excel 2003 was able to do it. I currently have Excel 2007. Please help.

Thank you very much.

EggHeadCafe - Software Developer Portal of Choice
A Wrapper for the Dispatcher class of Threading Namespace to manage thread items
http://www.eggheadcafe.com/tutorials...e-dispatc.aspx

separating multiples digit in a cell into individual cell
 

Hi,

You may use Data Text to columns. Select the appropriate delimiter in
step 2 of 3 (of Data Text to columns)

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"sierra spiegel" wrote in message ...
I have a series of number sets. When I copied from the MS Word and pasted
them into Excel, all of the numbers in the set are pasted into one cell. I
need those numbers to be in an individual cell. How do I do it? I think MS
Excel 2003 was able to do it. I currently have Excel 2007. Please help.

Thank you very much.

EggHeadCafe - Software Developer Portal of Choice
A Wrapper for the Dispatcher class of Threading Namespace to manage thread
items
http://www.eggheadcafe.com/tutorials...e-dispatc.aspx