HomeMicrosoft OfficeExcelSplit the Full Name to First Name and Last Name in Microsoft Excel 2016

Split the Full Name to First Name and Last Name in Microsoft Excel 2016

This blog will explain how to split the column that contains the full name to first name and last name in Microsoft Excel 2016 using the Text to Column command.

How to split full name to first and last name in Microsoft Excel 2016 using the Text to Column Command?

1. Select the column that contains the full name. In this example , the column A contains the data as shown in the screenshot.

image

2. Click the Text to Column button which can be found under the Data tab.

image

3. This will display the “Convert Text to Columns” Wizard. In the step 1 , Check the option “Delimited” and click the next button.

SNAGHTML110e6fdc

4. In the step 2 , check the option “Space” in the Delimiters group and then click the next button assuming that space is the delimiter in the full name that can split and return first name and last name.

image

5. In the step 3 , select the “Text” option from the column data format section and specify the destination cell from where you want to display the results and click “Finish”.

image

5. Immediately , you should see the results displayed in the selected cells.

image

Leave a Reply

You May Also Like

In this article, you will learn about the SKEW.P function, the formula syntax and usage of the function in Microsoft...
In this article, you will learn about the SKEW function, the formula syntax and usage of the function in Microsoft...
In this article, you will learn about the RANK.EQ function, the formula syntax and usage of the function in Microsoft...
  • Excel
  • November 23, 2021