HomeApplicationOffice information

How to separate first and last name in excel

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:

How to separate first and last name in excel Picture 1

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

How to separate first and last name in excel Picture 2

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

How to separate first and last name in excel Picture 3

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:

How to separate first and last name in excel Picture 4

3.5 ★ | 2 Vote

You should read it

May be interested

  • How to separate text strings by commas or spaces in ExcelHow to separate text strings by commas or spaces in Excel
    separating text strings based on commas or spaces is a trick that helps you split the characters in a parameter cell into different clusters based on commas or spaces that parameter cell contains. tipsmake will guide you how to separate text strings by commas or spaces in excel.
  • How to convert commas to dots in Excel - Convert unit separatorHow to convert commas to dots in Excel - Convert unit separator
    in excel, to separate units in data, we can use periods or commas. so how to convert a period to a comma or vice versa?
  • How to Convert Word to ExcelHow to Convert Word to Excel
    if you want to move a list or table of data from word to excel, you don't need to copy and paste each information into a separate cell in the spreadsheet. by properly formatting the word document first, you can easily import the document into excel with just a few clicks.
  • How to convert commas into dots in ExcelHow to convert commas into dots in Excel
    in excel, to separate units in a metric, we can use dots or commas. so how to convert the dot to a comma or vice versa?
  • How to Add a New Tab in ExcelHow to Add a New Tab in Excel
    you can add tabs in excel, called 'worksheets,' to keep your data separate but easy to access and reference. excel starts you with one sheet (three if you're using 2007), but you can add as many additional sheets as you'd like. open your...
  • How to separate negative and positive numbers in ExcelHow to separate negative and positive numbers in Excel
    to separate negative and positive numbers in excel at the same data table, we will use the if function.
  • Instructions for separating column content in ExcelInstructions for separating column content in Excel
    to separate content in an excel field into different columns, we can use two different ways.
  • How to split, merge first name in ExcelHow to split, merge first name in Excel
    how to split, merge first name in excel. normally you enter the list of staff, students, students .... the first name and last name fields are on the same column. however, in the process of working with some software, it is necessary to get the first and last name of the field ..
  • Split numbers from strings in ExcelSplit numbers from strings in Excel
    in the process of working with excel, i have encountered some cases that require separating only the fraction in a given string, now this post shares with you how to do this. the following article details how to separate numbers from a given string in excel.
  • What can the shortcut Ctrl + E in Excel do?What can the shortcut Ctrl + E in Excel do?
    the shortcut ctrl + e in excel is a very familiar shortcut and you can do a lot with this shortcut such as merging data in excel tables, separating data in excel,...

Office information