Column of names

[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.

 

[T. Valko]

Try these:

A1 = Doe, John

First name:

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

Last name:

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

Biff

 

[Stan Brown]

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.

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.