You will first need to transpose the data to be in one column only.

Select the column you want to split
In the "Data" menu, select "Text to Columns"
Select "Delimited" and then click "Next"
Check only the box next to Space, and maybe the one next to "Treat
consecutive delimiters as one" and then click "Finish"

This will split all cells in the column you selected and push the words to
the right in other cells as you described you need. You can then tranpose
the data to get the orientation you want.



"sparx" wrote:


Does anybody know of a formula that can look at a sentence of say 3 or 4
words and then look for the spaces inbetween the words and put each word
in a different cell underneath each other?


--
sparx
------------------------------------------------------------------------
sparx's Profile: http://www.excelforum.com/member.php...o&userid=16787
View this thread: http://www.excelforum.com/showthread...hreadid=515292