On Sun, 08 Mar 2009 09:27:10 -0400, Ron Rosenfeld
wrote:

If you really need to do it with a formula, you could use this UDF (user
defined function).

Forgot to include a sample formula:

=SplitSpace($A$1,COLUMNS($A:A))

--ron