Extract First Middle and Last Name without Left or Right Function
In this video, I have explained in detail that how can extract First Name, Middle Name and Last Name without using LEFT and RIGHT formulas. To perform this action I have used many text and logical functions with some logic.
You may checkout another video here to know how to extract First Middle and Last Name👇
• Extract the First, Middle and Last Na...
Watch this video till the end to know more in detailed
Functions used
MID Function👇
• Using LEFT RIGHT & MID Functions in E...
LEN and REPT Function👇
• Most Useful Function of Excel || Exce...
TRIM Function👇
• TRIM and CLEAN Function in Excel || D...
IF Function in Excel👇
• Excel IF Function
Substitute Functions👇
• Replace and Substitute Functions in E...
**********************************************
Subscribe to YouTube & Follow on Facebook Page👇
/ exceluniverse
www.facebook.com/exceluniverse.pkp
Download the Practice file from the link below👇
https://mega.nz/file/k6hRmKCA#tzeX7Gv...