seperate first and last name in excel for mac

Seperate first and last name in excel for mac full#

Seperate first and last name in excel for mac full#

Once done, you can delete the full name data if you want.Ī few things to know when using Text to Columns to separate first and last names in Excel:

You can choose to overwrite the data or cancel Text to Columns and manually remove it first. Note: In case there is any data in the cells already (the ones where Text to Columns output is expected), Excel will show you a warning letting you know that there is some data already in the cells. The above steps would instantly split the names into first and last name (with first names in column B and last name in column C). Step 3 of 3: Set B2 as the destination cell (else it will overwrite the existing data).Step 2 of 3: Select the Space option and click on Next.Step 1 of 3: Select Delimited (this allows you to use space as the separator) and click on Next.Make the following changes in the Convert Text to Column Wizard:.

In the ‘Data Tools’ group, click on the ‘Text to Columns’ option.

Select all the names in the column (A2:A10 in this example).

Text to Columns functionality in Excel allows you to quickly split text values into separate cells in a row.įor example, suppose you have the dataset as shown below and you want to separate the first and last name and get these in separate cells.īelow are the steps to separate the first and last name using Text to Columns:

Remove the Middle Name (or Just get the middle name).

Get the First or the Last Name from Full Name.

Separate First, Middle, and Last Names Using Formulas.