• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 942
  • Last Modified:

How to merge (concatenate) two columns into one, and optionally insert comma, in Excel?

Is there an easy built-in way, without macros, in Excel to merge (concatenate ) information in two columns, into one column? and optionally insert a comma between the two fields of information?

Example (and what i'm trying to do), I have two individual columns "First Name" and "Last Name", and I'd like to make one column out of it, combining first and last names.

Also, for the comma insertion part, I have "City" and "State" columns, and I'd like to concatenate those too, and put a comma between it.
0
flyawaymike
Asked:
flyawaymike
  • 4
  • 3
  • 2
  • +1
1 Solution
 
zorvek (Kevin Jones)ConsultantCommented:
Use a formula:

=A1&", "&B1

Select the formula results, copy, paste special, values.

Then delete the original columns.

Kevin
0
 
barry houdiniCommented:
If you have lastname in A2 and firstname in B2 you can use this formula in C2 to concatenate with a space
=A2&" "&B2
or with a comma
=A2&", "&B2
regards, barry
0
 
DaveCommented:
to merge A1 and B1 into C1
=A1& " " &B1
with comma
=A1&", " &B1


Then copy and past special over this column to remove the formula links so that you can delete columns A & B if needed

Cheers
Dave
0
Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

 
DaveCommented:
Kevin.

As I was saying ......
0
 
zorvek (Kevin Jones)ConsultantCommented:
0
 
DaveCommented:
Ellipses Dude .... I love it.
0
 
zorvek (Kevin Jones)ConsultantCommented:
Shhh. He has no idea :-)
0
 
flyawaymikeAuthor Commented:
oh nice! i didn't realize you could use the "&" in there that.

that's pretty cool actually, I'm going to have to pickup a book or guide or something on formula usage in Excel.   Thanks!!!
0
 
zorvek (Kevin Jones)ConsultantCommented:
Or just ask more questions ;-)
0
 
flyawaymikeAuthor Commented:
oh thanks too, brett, I'm sorry, is there a way to award points to you too?  

the copy special was a crucial thing I realized I needed too, when I just deleted the old two fields and was like "Doh!".
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 4
  • 3
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now