how to separate words between blanks

E

Elizabeth

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?
 
V

Vinod Winston

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
Click to expand...

If it works please vote for this answer..
 
Top