View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
widman widman is offline
external usenet poster
 
Posts: 103
Default Find and replace

Is it possible to replace with a caraige return?
I received a file with about 5000 words in one cell, separated by commas
every few words. Is there a way to use a "replace" to replace the commas
with a return so it breaks up onto about 1400 lines?

Or some other way to break it up into a usefull list?