Click on cell A2 and then type & in the formula.

Click on cell C2 (or the row where the information you want to combine is).While concatenate works well, there is actually a shortcut that you can use which involves the ampersand ‘&’: =CONCATENATE(A1 ” “,B1 ” “,C1) in column D1. If for example you have three columns (A1, B1, and C1) you would enter the formula: If you have more than two columns you would like to combine, then simply add a comma after each cell. 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. The problem is, there will be no space inbetween the letters or numbers, so you will need to edit the formula to read: You should see the two cells are now combined in cell C2, with the formula for cell C2 reading: Clicking on cell B2 and closing the formula with a closing bracket.Clicking on cell A2 and then adding a comma ( ,).Clicking on cell C2 (or the row where the information you want to combine is).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: Did you know though that the concatenate formula can also do this for you? Using the concatenate formula to combine cells But, when it comes to working out how to combine the content of different cells into a new one, without adding them together, many users will simply cut and paste.

If you use Excel there is a good chance that you have used a wide variety of formulas.

Concatenate rows in excel with comma