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.