How to separate first and last name in excel

How to separate first and last name in excel

How to separate first and last name in excel

How to separate first and last name in excel

In this Microsoft Excel blog post we will tell you, how to separate first and last names in Excel.

In many places we need data to be separated from the first name and last name so this Excel formula will make it very easy for you.

How to split first and last name in excel

First Name in excel

Below are some names in column A that are shown in the picture below to illustrate to you.

The first name in column B is then separated with the help of the Excel formula. It uses the RIGHT and SEARCH excel formulas.

With the RIGHT excel formula you target the word in the cell by the right hand.

And with the help of the SEARCH excel formula, we search the space in the cell to see where the space is.

Because in the RIGHT excel formula we have to tell us the words written in the cell by the right hand and how many words they can pick up.

How to split first and last name in excel

Last Name in excel

And now the last name in column C is separated using the Excel formula. It uses the formula LEFT, LEN and SEARCH excel formulas.

The LEFT Excel formula targets the word written in this cell on your left hand side, in this formula you also have to tell it how many words to target, We have done this with the help of LEN and SEARCH Excel formulas.

The LEN excel formula specifies the number of words used in any cell with spaces.

And with the SEARCH excel formula, we search the space in this cell by the left-hand side as described earlier in this post.


How to split first and last name in excel

After learning this Excel formula, your answers to the following questions will be answered

How to separate first and last name in excel
How to split first and last name in excel
How to separate first name and last name in excel
How to split first name and last name in excel
How to split full name in excel
How to separate full name in excel
How to separate last name first name in excel
How to separate last name and first name in excel

Leave a Reply

Your email address will not be published. Required fields are marked *