Use Excel first and last name separator function, Left function, Right

Sometimes in Excel, you want to separate first and last name to support work, so please refer to Excel First and Last Name Separation function, Left function, Right function to be able to separate last name, first name as you like, work more efficiently and quickly, instead of manual separation.

Separating first and last names in Excel There are several ways to do it through basic functions in Excel or command line, below we will use some basic functions in Excel such as Left, Right functions, please follow and do it with us.

Use the Left, Right functions to separate first and last names in Excel

Excel first and last name separator function, Left, Right function

Suppose we have a table with Full Name information as shown below:

You perform the separation by following these steps:

Step 1: You place your mouse pointer in a certain cell in the Last Name column, and then type a formula

=LEFT(D3,FIND(” “,D3,1)-1)

(D3 is the cell containing the full name data)

In the above formula, The LEFT function has the function of cutting the character string on the left side with the condition of cutting from the first space in cell D3. Therefore, with the character string in cell D3 as Nguyen Van Hoa, the word “Nguyen” will satisfy the condition of the formula and separate the character string bearing the value of Last Name into 1 separate cell.

Step 2: You hover over the corner of the cell you just typed the formula so that the black plus sign “+” appears like the show, then hold down and drag the mouse down to the remaining cells to apply the function to the whole column.

And here is the result after you split the Last Name column of the Student Name column in Excel:

Step 3: Continue separating the Student Name in the table by placing the mouse pointer in any cell in the Student Name column, and then typing the command:

=RIGHT(D3,LEN(D3)-FIND(” “,D3,1))

(D3 is the cell containing the full name data)

In the above formula, the RIGHT function has the function of cutting the character string on the right side provided that the cut satisfies the LEN character counting function in cell D3

Step 4: You do the same as step 2, you hover your mouse in the corner of the cell just typed the formula so that a black “+” plus sign appears, then hold down and drag the mouse down to the remaining cells to apply the function to the whole column -> then you will separate Excel First and Last Name in the whole list as shown in the below screenshot:

So you have just finished working with us to use the First and Last Name Separation function in Excel with the LEFT function and the RIGHT function, the steps for you to separate First Name and First Name are quite simple, so you just need to take a closer look to understand and manipulate.

https://thuthuat.taimienphi.vn/ham-tach-ho-va-ten-trong-excel-ham-left-right-43229n.aspx
In addition, Excel has many commands and shortcuts that can support and help in the process of working with Excel. You can refer to the Excel shortcut article that Software has shared and introduced for reference! If you want to insert unique special characters into Excel files, you can also refer to the tutorial How to insert special characters in Excel. Good luck.