strip first word from a text cell

[Excelandy]

Help
How do I strip the first word from a text entry in a cell and place i
in the adjacent column.

Andy

 

[graphguy]

give example of how the text look

 

[Frank Kabel]

Hi
try
=LEFT(A1,FIND(" ",A1)-1)

 

[Domenic]

Assuming that the first and second words are separated by a space, tr
the following...

=LEFT(A1,FIND(" ",A1)-1)

Hope this helps!