how to separate words between blanks
 

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?

There's a simplest way to this query...

type the sentence in a cell.. eg: "Hello how are you"
then cut (CTRL+X) words "how are you"
And paste it in a different cell
The words are automatically split into seperate columns

If it works please vote for this answer..

"Mexage" wrote:

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?