Merging fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
=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.
 
Try using a concatenate function like =CONCATENATE(B2&", ",A2) or
=B2&", "&A2. I prefer the later.
 
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.
 
Back
Top