On Wed, 22 Feb 2006 07:38:30 -0600, 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?

1. Use the Data/Text to Columns wizard with <space as the delimiter.

or

2. Download and install Longre's free morefunc.xll add-in from
http://xcell05.free.fr

Then, with your sentence in A1:

B1: =REGEX.MID($A1,"\w+",COLUMNS($A:A))

and copy/drag across as far as needed.

If it is an issue, there is an option to distribute the morefunc.xll add-in
with the workbook.


--ron