Excel Formulas to Join the First and Last Name ~ Simple Tips!!
Tags: excelformula, excelformulas
Published: 2021-07-06 04:19:59

---
title: Excel Formulas to Join the First and Last Name ~ Simple Tips!!
published: true
date: 2021-07-01 13:54:46 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-join-the-first-and-last-name/
---

For instance, you have a list of first names and last names in separate columns in Excel. Here need to **join the first and last name and return it to the single cell**. How could you deal with this task in Excel? This article will show you some methods to achieve it. Let’s dive into this article!! Get an official version of ** MS Excel**  from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

[![Join the first and last name](https://geekexcel.com/wp-content/uploads/2021/06/Join-the-first-and-last-name.png)](https://geekexcel.com/excel-formulas-to-join-the-first-and-last-name/join-the-first-and-last-name/#main)<figcaption id="caption-attachment-48239">Join the first and last name</figcaption>

## Generic Formula:

- If you want to join the first and last names in Excel, you can use the below formula.

**=first&” “&last**

## Syntax Explanations:

- **First** – It represents the first name of the full name.
- **Last** – It represents the last name of the full name.

## Practical Example:

Refer to the below example image.

- First, we will enter the input names such as the first name, and last name in **Column B** , and **Column C**.
- Here we need to join these two names.

![Input Ranges](https://geekexcel.com/wp-content/uploads/2021/07/Input-Ranges-2.png)<figcaption id="caption-attachment-48242">Input Ranges</figcaption>

- Select any cell and type the above-given formula.

![Enter the formula](https://geekexcel.com/wp-content/uploads/2021/07/Enter-the-formula.png)<figcaption id="caption-attachment-48241">Enter the formula</figcaption>

- Finally, press the ** ENTER**  key, you can get the result as shown below.

![Result](https://geekexcel.com/wp-content/uploads/2021/07/Result1.png)<figcaption id="caption-attachment-48240">Result</figcaption>

## Wrap-Up:

Here we have described the formulas to **join the first and last name in Excel**. If you have any **doubt** regarding this article or have any other **questions** related to Excel, let me know in the **comments** section below.

Thank you so much for visiting  **[Geek Excel](https://geekexcel.com/)!! **If you want to learn more helpful formulas, check out [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!! **

### Read Also:

- **[Excel Formulas to Calculate the Volume of a Rectangular Prism!!](https://geekexcel.com/excel-formulas-to-calculate-the-volume-of-a-rectangular-prism/)**
- **[Excel Formulas to Create Email Address with Name and Domain!!](https://geekexcel.com/excel-formulas-to-create-email-address-with-name-and-domain/)**
- **[How to Insert a Date or Formatted Date in Excel Office 365?](https://geekexcel.com/how-to-insert-a-date-or-formatted-date-in-excel-office-365/)**
- **[Excel Formulas to Get the Last Name from Full Name ~ Quick Tricks!!](https://geekexcel.com/excel-formulas-to-get-the-last-name-from-name/)**
- **[Excel Formulas to Get Name From Email Address ~ Useful Guide!!](https://geekexcel.com/excel-formulas-to-get-name-from-email-address/)**