View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default Most Interesting Problem I Had Ever Got.

Hi
not sure I understood you correctly. But lets give it a try. So you
want to put alls words in one column as long as two spaces occur?. If
yes I'd do the folowing:
- Start a word-editor of your choise
- Replace double spaces with a delimiter of your choise (,)
- Import the text an choose this delimiter as separator

If this does not work it would be goot if you can procide a sample data
line from your file an the expected result

HTH
Frank