How To Split First And Last Name In Excel

In Excel, to split the first and last name, you can use the “Text to Columns” function and select the “Space” delimiter.

In today’s digital era, managing and manipulating data efficiently is of utmost importance. Excel, a powerful spreadsheet software, offers numerous functions and features that help us streamline our data analysis tasks. One such crucial task is splitting the first and last names of individuals when they are presented together in a single cell. In this blog post, we will explore different methods and techniques to split the first and last name in Excel, enabling us to organize and analyze our data effectively. So, if you’ve ever struggled with separating names in Excel, stay tuned for some handy tips and tricks that will simplify your data processing workflow.

How To Split First And Last Name In Excel: Step-by-Step


Step 1: Identify Columns,

In a dataset or spreadsheet, locate the column that contains the full names that need to be divided or separated into separate columns for first name, middle name (if available), and last name.

Next Step

Step 2: Create Extra Columns,

By creating two additional columns, ‘First Name’ and ‘Last Name’ beside the existing column of full names, we can efficiently separate and organize names into their respective parts. This allows for easier data manipulation and analysis while maintaining the integrity of the original data structure.

Next Step

Step 3: Highlight the Column to Split,

To highlight the entire column, simply click on the column with the full names. This action will select and visually distinguish the entire column, making it easier to work with or apply specific operations to the data within that column.

Next Step

Step 4: Access Data Tools,

After highlighting the column, go to the “Data” tab in the Excel menu. Look for the “Data tools” section and access various functions to manipulate, analyze, and organize the data in your selected column.

Next Step

Step 5: Click on Text to Columns,

Within the Data Tools group, navigate to ‘Text to Columns’ and select it. A Wizard will open, guiding you through the process of splitting text into different columns based on chosen delimiters.

Next Step

Step 6: Select “Delimited”,

In the wizard that opens, select the “Delimited” option which will allow you to specify the format for separating your data. Clicking Next will proceed to the next step.

Next Step

Step 7: Choose the Separator,

In order to choose the space as a delimiter, select the checkbox labeled ‘Space’. If the names in your data are separated by a different character, you can choose or input the appropriate separator. Finally, click on the “Next” button to proceed.

Next Step

Step 8: Preview Data,

Before moving on to the next step, take a moment to preview your data. At this stage, ensure that your data is displayed in two distinct columns. Once you have confirmed this, proceed by clicking on the “Next” button.

Next Step

Step 9: Choose the Destination,

After selecting the desired location in Excel for the new columns, you have the option to choose the ‘First Name’ and ‘Last Name’ cells which were already created. Once you click ‘Finish’, the process is complete.

Next Step

Step 10: Review Your Result,

After completing the previous step, there should be a clear distinction between the first and last names as they are now organized into two separate columns. This separation allows for easier retrieval and manipulation of individual names within a dataset or database.


In conclusion, splitting first and last names in Excel can be easily accomplished by utilizing the power of Excel’s text functions. By using formulas such as LEFT, RIGHT, FIND, and LEN, we can accurately extract the first name and last name from a full name cell.

By following the step-by-step guide provided in this blog post, you can efficiently split first and last names in Excel, regardless of the format or length of the full names. This skill can be particularly beneficial in scenarios where you need to organize or analyze data based on individual names.

Remember to consider the variations in name formats and adjust your formulas accordingly. Additionally, always be cautious of leading and trailing spaces, as they can affect the accuracy of the split.

Now that you possess the knowledge of how to split first and last names in Excel, you can streamline your data processing tasks and improve your overall efficiency. So go ahead, put these techniques to use and make the most out of Excel’s powerful text functions.

Table of Contents