Try using a concatenate function like =CONCATENATE(B2&", ",A2) or
=B2&", "&A2. I prefer the later.
--
Kevin


" 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