Try this:

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

Biff

"Brennan" wrote in message
...
I need to extract the first name from one cell and put it into another
column.

Example:

John Smith John
Andrew Johnson Andrew
Michael White Michael

I'm sure its pretty easy, but I can't seem to figure it out. Can anyone
help?