re-arrange text

[Guest]

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

 

[Guest]

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