Microsoft Excel – Merge Cells

Example:

The example may be easier to understand if you copy it to a blank worksheet.

Column (A) – First Name: Sara
Column (B) – Last Name: Davis
Column (A) – First Name: Brad
Column (B) – Last Name: Sutton

Formula Description (Result)

=A2&” “&B2 Combines the names above, separated by a space (Sara Davis)
=B3&”, “&A3 Combines the names above, separated by a comma (Sutton, Brad)
=CONCATENATE(A2,” “,B2) Combines the names above, separated by a space (Sara Davis)

Note The formula inserts a space between the first and last names by using a space enclosed within quotation marks. Use quotation marks to include any literal text — text that does not change — in the result.