SPLIT names in Excel - Separate First, Middle and Last Name

Опубликовано: 13 Октябрь 2024
на канале: Excel Bootcamp

18,251

How to split names (first, middle or last) from a full name?

In this video, I'll show you how to use the fastest method to Split / separate names in Excel.
This tutorial is a part of our data cleansing series.

--------------------
IMPORTANT
--------------------
How to install an Excel add-in?
• Video

How to fix the disappearing ribbon in Excel?
• How to Fix / Enable the Disappearing ...

--------------------
QUESTIONS
--------------------
If you have an issue don't hesitate to write to us:
https://excelkid.com/add-ins/

Instead of boring techniques (LEFT formula, RIGHT formula, MID formula, FIND formula), we'll use something new. DataXL is a free add-in for cleaning data in Excel.

You can download the add-in from our website for free.
To extract the first name from a full name, use the TextLeft function.
The TEXTLEFT function returns the first word from the source range using the specified delimiter.
Enter the formula.
Add a source range.
Use space as a delimiter.
If you want to extract the middle name from a full name, use the TextMid function.
The TEXTMID function returns the text between two delimiters.
Enter the formula.
Select the source range, add the first delimiter.
Finally, add the second delimiter.
To extract the last name from a full name, use the TextRight function.
The TEXTRIGHT function returns the last word from the source range using the specified delimiter.
Enter the formula.
Select the source range. Add a delimiter, in this case, space.
Text to columns in Excel? From now it's a quick task. Save your time and boost your productivity in #Excel!

#splitnames #cleandata