View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Radrays Radrays is offline
external usenet poster
 
Posts: 14
Default Convert text to rows

I am currently using 2007 - I have about 20,000 rows by 12 columns of
information in a spreadsheet.

Column "G" cells will at times have more than 1 number in it.
How can I split the cell so each number within that cell is in it's own row?

Thank you.