[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 938
  • 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
 
Dave BrettCommented:
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
Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

 
Dave BrettCommented:
Kevin.

As I was saying ......
0
 
zorvek (Kevin Jones)ConsultantCommented:
0
 
Dave BrettCommented:
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

Featured Post

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

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