Split Last Name in Excel
In this video you learn "How to Split Last Name in Excel using a single formula.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 complete name given and they want only Last Name.
We all know there is no particular in-built function in Excel which allows Split Last Name from Complete Name.
We've good way to resolve this type of problems with using a single formula only. After watching this tutorial, you will become an expert of splitting names in Excel.
We have created this tutorial using following features:
1. SUBSTITUTE FUNCTION
2. REPT FUNCTION
3. RIGHT FUNCTION
4. IF FUNCTION
5. ISERROR FUNCTION
6. SEARCH FUNCTION
In case of any simple or complicated "EXCEL" QUERY, You can join our WhatsApp Group for instant solution @
Click on below link to join group:-
https://chat.whatsapp.com/BymUIDEt3ME...