Column of names

  • Thread starter Thread starter Invalid
  • Start date Start date
I

Invalid

I have a bunch of names (shown as Doe, John) in column A. How can I show
the first names in B column and last in C? I understand how to copy
formulas in B and C and paste values.
 
Try these:

A1 = Doe, John

First name:

=MID(A1,FIND(",",A1)+2,255)

Last name:

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

Biff
 
Mon, 07 May 2007 03:58:32 GMT from Invalid
I have a bunch of names (shown as Doe, John) in column A. How can I show
the first names in B column and last in C? I understand how to copy
formulas in B and C and paste values.
Click to expand...

In B1:
=REPLACE(A1,1,1+FIND(",",A1),"")
That assumes last and first are separated by comma-space. If it's
just comma, no space, use
=REPLACE(A1,1,FIND(",",A1),"")

In C1:
=LEFT(A1,FIND(",",A1)-1)

These formulas will fail on any cells in A that don't have a comma.
 
Back
Top