View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ashish Mathur[_2_] Ashish Mathur[_2_] is offline
external usenet poster
 
Posts: 1,766
Default 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