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

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?

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

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


--
Mikeopolo
------------------------------------------------------------------------
Mikeopolo's Profile: http://www.excelforum.com/member.php...o&userid=18570
View this thread: http://www.excelforum.com/showthread...hreadid=519818

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

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


"harriet" wrote:

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?