Try the "Text to Columns" function under the Data menu.

Then select delimited and after clicking on OK select the Space option to
split at each space.

Hope that helps, and if it does please vote for this answer

G.Morales

"Elizabeth" wrote:

I have a database where the names contain several words (names). I want to
break them up so that there is a word (name) in each column. For example, if
the entry is "A B C", I want to make three columns with "A" in one, "B" in
the second, and "C" in the third. Anyone have any ideas?