re-arrange text

S

snugs25

How can i re-arrange a list of text (which are names) in such a way: for
example changing

Bob Smith
to:
Smith, Bob.

is there an easier way of doing it than manually so that i can apply it to a
large list?

Thanks!
Gem
 
C

CLR

Assuming your list in column A, put this in B1 and copy down........

=MID(A1,FIND(" ",A1,1),99)&", "&LEFT(A1,FIND(" ",A1,1))

Vaya con Dios,
Chuck, CABGx3
 
Top