how to concatenate more than 1 word in a column?

[ticc888]

if i have company names in a column ..

with more than 1 word, how do i break it up into parts and put each word of the company name into different columns?

any ideas?

 

[tactps]

Hightlight the column you want and choose "text to columns" from the data manu