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