take first name out of column & put it in another column

H

harriet

Hi there & I sure would appreciate help. I send you many thanks ahead of
time!!
I have tons of name in one column:

lastname firstname

I want to take the lastname and put it in a column by itself.

Can anyone help me?
 
M

Mikeopolo

One way:

If A1 contains

Dagg Fred

Then in B1 type =LEFT(A1,FIND(" ",A1)-1)

This assumes that there is only one first name and one surname, and
there is a single space between them

Regards
Mike
 
E

Elkar

Assuming none of your Last Names have spaces in them (like Van Buren), this
should work:

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

HTH,
Elkar
 
Top