Split First, Middle, Last Names of the Full Name in Excel Office 365!!
Tags: kutoolsexceltutorial, stepstosplitfirstmid, kutools
Published: 2020-10-08 08:05:43

---
title: Split First, Middle, Last Names of the Full Name in Excel Office 365!!
published: true
date: 2020-10-08 03:53:50 UTC
tags: KutoolsExcelTutorial,StepstoSplitFirstMid,Kutools
canonical_url: https://geekexcel.com/split-first-middle-last-names-of-the-full-name-in-excel-office-365/
---

In this guide, you will learn the steps to **Split/Separate First, Middle, Last Names of the Full Name in Excel Office 365** using **Kutools.** Let’s step 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)

**Note:** [kutools for Excel](https://geekexcel.com/get-kutools-for-ms-excel-2019-2016-2013-2010-2007-office-365/) has more than 180 features which are used to complete the difficult task with several clicks. If you want to use Kutools, you need to install it from Excel’s official website.
## Split/Separate First, Middle, Last Names of the Full Name:

You can use the Kutools Split Names option to split first, middle, last names and displayed in separate columns. To do this follows the below steps.

- Let’s consider the below **example name list** , where you can see the names in the cell range **A2:A8,** and we are going to separate them into different columns.

![Example Name list](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Example-Name-list.png)<figcaption id="caption-attachment-15353">Example Name list</figcaption>

- You need to **select the name cells** that you want to split, then on the **Kutools Tab, select** the **Merge & Split** option, **choose** the **Split Names** option from the drop-down menu.

![Select the Split Names option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Select-the-Split-Names-option.png)<figcaption id="caption-attachment-15354">Select the Split Names option</figcaption>

- It will open the **Split Names dialog box**.
- In that dialog box, you need to **check** the **First name, Middle name, Last name** option under the **Split type** section.
- Now, you need to **click** the **OK** button.

![Split Names dialog box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Split-Names-dialog-box.png)<figcaption id="caption-attachment-15355">Split Names dialog box</figcaption>

- Then, the Split Names prompt box will pop out to ask you the location that you want to display the result.
- You need to **select any cell** and **click** the **OK** button.

![Prompt Box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Prompt-Box-1.png)<figcaption id="caption-attachment-15356">Prompt Box</figcaption>

- Finally, you can get the result in separate columns as shown in the below screenshot.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Result-6.png)<figcaption id="caption-attachment-15357">Result</figcaption>

### Note:

- If you **forget** to **select the input** range, you can **use** the **browse** button to select the range.
- This feature supports the undo ( **CTRL + Z** ) option.

## Summary:

In this guide, you can clearly understand the steps to **Split/Separate First, Middle, Last Names of the Full Name in Excel Office 365** using **Kutools. ** Give your **suggestions** in the below comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!

### See Also:

- [Convert Between Roman Numerals and Numbers in Excel](https://geekexcel.com/convert-between-roman-numerals-and-numbers-in-excel-office-365/)
- [Reverse Order of Characters in a Cell with Functions in Excel](https://geekexcel.com/reverse-order-of-characters-in-a-cell-with-functions-in-excel-office-365/)