Automatically cut the first word in a cell and move to another cell

[Frederico2]

Hi again,
If I have cells like this;

Monkeys ate cheese
Elephants said “Woooo!” to monkeys

How can I automatically cut the first word from each cell and paste in it’s own column? Like:

Monkeys        ate cheese
Elephants       said "Woooo!" to monkeys

Thanks!

LeroyG added format after “Like:”

[EarnestAl]

You would need a macro to cut text from the cell you are in.

On the other hand by using two extra columns you could copy parts of the cell into two cells. Assuming the text is in A1, then

• in cell B1 enter =LEFT(A1;FIND(" ";A1)-1)
• in cell C1 enter =MID(A1;LEN(B1)+2;LEN(A1)-LEN(B1))

[Frederico2]

Thanks!