Home Application Office information

How to separate first and last name in excel

How to separate names in Excel? This may seem simple but not everyone knows?

You are an office worker and often have to work with lists of many names. Are you looking to separate the first and last name from the list? So what to do? The following article, TipsMake will guide you to read the steps as follows!

Perhaps this is the most common problem of office people.So let's not spend too much time with it.

Suppose we have to separate the first and last names from a list of the following 5 people:

Picture 1 of How to separate first and last name in excel

1.Speed ​​name

  1. Copy column A to column C.
  2. Specify the names that need separating first and last names in column C
  3. Press Ctrl + F to open the search and replace dialog box
  4. In the Find what dialog box in the Replace window, type: * _ (asterisk and space)
  5. Select Replace All and wait for the miracle

Picture 2 of How to separate first and last name in excel

As a result, you have separated the name from the full name list.

Picture 3 of How to separate first and last name in excel

2. Separate the rest of the name.

So what about the rest of the name?Simple, please:

  1. Point the mouse over cell B1
  2. Enter the following formula: = LEFT (A1, LEN (A1) -LEN (C1))
  3. Copy the remaining cells

So you have a complete list of first and last names:

Picture 4 of How to separate first and last name in excel

You've just finished reading the article "How to separate first and last name in excel" edited by the TipsMake team. You can save how-to-separate-first-and-last-name-in-excel.pdf to your computer here to read later or print it out. We hope this article has provided you with many useful tech tips and tricks. You can search for similar articles on tips and guides. Thank you for reading and for following us regularly.

« PREV How to display the Ruler bar in Word versions
NEXT » Do you know the structure and usage of the LEFT function in Excel?
Read more