If first name is in column A and Last name in B then in C put

=B1& ", "&A1

and copy down

--
-John Northwest11
Please rate when your question is answered to help us and others know what
is helpful.


" wrote:

Hello,

In two columns I have a First Name and in the Second columne I have a last
name is it possible for me to convert the firstname and the lastname into one
field? for example |Doe, John|. I have over 500 names I would need to convert
or merge. How do you advise

Thanks,

Kelly