Excel - Combine = Concatenate
Need to combine the text of two cells into one cell in Excel, such as combining the first and last names into column C below?
Combine First and Last Names in One Cell
In cell C1, type
=A1&" "&B1. The result is "Nancy Davolio" in cell C1. The space between the quotation marks in the formula inserts a space between the two names.
To reverse the order of the names, type
=B1&", "&A1. The result is "Davolio, Nancy" in cell C1. The comma and the space between the quotation marks in the formula insert a comma and a space between the names.
Note: You can also combine text by using the CONCATENATE function:
=CONCATENATE(A1," ",B1), but it's faster to just type the ampersands.