How to Combine Data From Different Cells in Excel

  • MORE

It's a very common situation. You have a worksheet with different pieces of data in different columns or rows that you need to put together into a single cell. Perhaps you have a list of people whose first, middle and last names are all sitting in different columns. Maybe you have a set of addresses where the street, city and postal code are in adjacent columns but you need to put them together for generating a mailing list. 

shutterstock 338731511Fortunately, Excel 2016 (and all prior versions) make it very easy to grab data from many different cells and put it into one. Just don't confuse this "combining" with "merging," another Excel procedure which causes one cell to span across multiple columns, but only uses the content from that single cell. To combine cells in Excel:

1. Select a location where you want the new, combined cell(s) to appear. Most likely, you'll want to pick a new column that's to the right of your other cells, but you don't have to.

select cell

2. Type =B2&C2 into the formula bar where B2 and C2 are the addresses of the cells whose data you want to combine (it could be any two cells). You can use an unlimited number of ampersands to add an unlimited number of cells.

enter cells in formula box

3. Include spaces between cells by adding &" " to the forumla. Anything within the quotes will be rendered so it could be a space, a comma or any text you want.

enter spaces

4. Hit Enter to see how it renders

output

5. Copy and paste your formula to reproduce the results in other rows.

copy across multiple rows

Author Bio
Avram Piltch
Avram Piltch, LAPTOP Online Editorial Director
The official Geeks Geek, as his weekly column is titled, Avram Piltch has guided the editorial and production of Laptopmag.com since 2007. With his technical knowledge and passion for testing, Avram programmed several of LAPTOP's real-world benchmarks, including the LAPTOP Battery Test. He holds a master’s degree in English from NYU.
Avram Piltch, LAPTOP Online Editorial Director on
Add a comment