Have you ever been working with a list in Excel and had to combine more than two cells into a new cell? The seemingly easiest way to do this is to copy the contents from both cells and paste them into the new cell, then edit them for spacing. But, did you know that there is actually a formula called concatenate that you can use to combine contents and display this in new cells?
Using the concatenate formula to combine cells
If, for example, you have a spreadsheet with first names in column A, last names in column B, and want to combine them into column C to display the full name you can do so by:
Clicking on cell C2 (or the row where the information you want to combine is)
Clicking on cell A2 and then adding a comma (,)
Clicking on cell B2 and closing the formula with a closing bracket
You should see the two cells are now combined in cell C2, with the formula for cell C2 reading:
The problem is, there will be no space inbetween the letters or numbers, so you will need to edit the formula to read:
The double quotations with a space in between them tells Excel to add a space to the cell in between the contents of A2 and B2.
If you have more than two columns you would like to combine, then simply add a comma after each cell.