Thread: Need to separate multiple numbers in one cell
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
sierra spiegel sierra spiegel is offline
external usenet poster
  
Posts: 18
Default 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
Reply With QuoteReply With Quote