Merging fields

[Guest]

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

 

[Guest]

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

=B1& ", "&A1

and copy down

 

[Dave Peterson]

=b1&", "&a1

But keep the original two columns. You'll be happy when you have to use just
the first name or just the last name.

Hide them if you have to, but keep them.

 

[Guest]

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

 

[Guest]

Great that is exactly what I was my expected outcome

So now that I am able to place the names in the same column, how would I
eliminate the columns A and B with keeping the new format that I have
greated. I have attempted to delete the columns with the fname and the lname
and the format is deleted as well.