View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Michelle Michelle is offline
external usenet poster
 
Posts: 204
Default I want to separate text at all the full stops

I know I can do this with text-to-columns, but I may have more than 256
strings in my text-file seperated by full stops, and I can't always use
2007.

What I need is a kind of 'Text-to-Rows' feature, so that it puts each string
into the next cell down

Is there an easy way to do this?

M