View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Moss Moss is offline
external usenet poster
 
Posts: 1
Default Change the Data in a Cell

I have tons of random #'s in one cell seperated by commas.

For example: In one cell--03, 04, 05, 06, 07, 08, 09, 10, 11, 14, 15, 2, 3,
41, 51, 52, 53, 57, 61, 63, 68, 75, 80, 81, 84, 85, 87, 89, 91, 94, 95, 97

How can I display the data vertically in seperate rows for each # without
doing it manually?

Please Help!