View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Andrei Andrei is offline
external usenet poster
 
Posts: 53
Default Macro that takes words from a sentence and puts them in diff cells

I need a macro which takes every word from a sentence in a cell and puts it
in a different cell

Example :

A1 : Mother and father are gone on vacation

What i need is a macro which does this :

B1 : Mother
C1 : and
D1 : father
E1 : are
F1 : gone
G1 : on
H1 : vacation