Combine First And Last Names In Excel & Google Sheets

Home » How To Combine First And Last Name In Excel » Combine First And Last Names In Excel & Google Sheets

Maybe your like

Return to Excel Formulas List

Written by

Editorial Team

Reviewed by

Steve Rynearson

Last updated on October 28, 2023 Download Example Workbook

Download the example workbook

This tutorial will demonstrate how to combine first and last names in Excel and Google Sheets.

Combine first and last names

Combine Names – Ampersand Sign (&)

To combine first and last names, use the ampersand (&) to join the names together. Additionally, use ” ” to create a space so the first and last names are separated.

=B3 & " " & C3

combine first last names PIC01

Combine Names – CONCAT Function

We can use the CONCAT Function to achieve the same result.

=CONCAT(B3,"",C3

combine first last names PIC02

NOTE: the CONCAT Function in Excel has replaced the CONCATENATE Function. While they are both still available, it is advisable to now use the CONCAT Function.

Try our AI Formula Generator

Generate

Last Name, First Name

To create a name format like “last name, first name”, we can use the & sign and a comma in a text string.

=C3 & ", " & B3

combine first last names PIC03

Last Name, First Name – CONCAT Function

We can use the CONCAT Function to achieve the same result.

=CONCAT(c3,",",B3

combine first last names PIC04

Combine First and Last Names in Google Sheets

These formulas work exactly the same in Google Sheets as in Excel.

combine first last names Google Function

AI Formula Generator

Try for Free

AI Tools

  • Excel Help Bot
  • Formula Generator
  • Formula Explainer
  • VBA Code Generator
  • VBA Code Commenter
  • Excel Template Generator

Excel Practice Worksheet

practice excel worksheet

Practice Excel functions and formulas with our 100% free practice worksheets!

  • Automatically Graded Exercises
  • Learn Excel, Inside Excel!

Free Download

Return to Excel Formulas List

← Sum Text in Excel & Google SheetsGet Day Name From a Date – Excel & Google Sheets →

Try our AI Formula Generator

Generate =SUMIF(A:A, "Q1", B:B)

Tag » How To Combine First And Last Name In Excel