Extracting First Name and Last Name from Cell with Full Name in Excel
In this Episode of Expert Excel with Dr. Chang, we are exploring how to extract the first and last name from a cell that contains the full name.
There are two approaches:
00:00:39 - Smart Fills
Type the first name next to the name
In the next row, type the first name, and Smart Fill will suggest the remainder
Rinse and Repeat for last name
00:01:16 - Using Functions
Explaining the Functions and Calculations
00:02:17 - Demonstration Using Functions
Use =Find(" ", Cell) to find the SpacePosition
Use =Left(Cell, SpacePosition-1) to Get First Name
Use =Len(Cell) to find NameLength
Use NameLength-SpacePosition to find how CharactersInLastName
Use =Right(Cell,CharactersInLastName) to get the Last Name
Resource File:
https://bit.ly/3eNUVrF
If there are any requests for Excel Tips and Tricks, please write them down in the comment and I'll try to create a video answer in the future.
By Asst. Prof. Dr. Pisal Setthawong
Department of Digital Business Management
Assumption University
Facebook:
/ pisal.setthawong
Music Credits:
Cyberleaf Studio - TechShow Loop 1