This video shows “How to extract First, Middle and Last Name from One Cell into Separate Cells in Excel using multiple ways”.
This is one of the very common situation which almost every user must have faced in his/her life. Either they get data from other team members in such a way where the names are given in one single column and then they have to split into different cells by their First, Middle (if any) and Last Name.
We all know there is no particular in-built function in Excel which allows extracting first, middle and last name from a cell.
We’ve explored two methods of doing the same. And, after watching this tutorial, you will become an expert of extracting names or text into different cells.
We have created this tutorial using following features:
1. Text to Column feature
2. LEFT function
3. SEARCH function
4. IF (logical) function
5. LEN function
6. SUBSTITUTE functions
7. TRIM function
8. RIGHT function
9. REPT function
Visit us for daily dose of Excel Tips & Tricks at