**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**

**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,

* 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,

**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

**. Good luck.**the tutorial How to insert special characters in Excel