Split Full Name to FIRST, MIDDLE and LAST Name in Excel with Formula│LEFT RIGHT MID and FIND Formula

In this video learn How to Split Full Name to First and Last Name in Excel with right mid and left function in Hindi
~~~~~~~~~~*Time Link to Watch Next Step*~~~~~~~~~~
01:39 - Find 1st Space for Name.
01:54 - Find 2nd Space For Name.
02:29 - Remark for the Whole video.
02:53 - How to Find the Last name in TWO WORD NAME.
03:22 - First Name In Three Word
04:00 - Last Name In Three Word
06:09 - Middle Name in Three Word
Leave Your Mail ID in Comment to get this Video Excel Sheet.
In the Video, the active cell contains this formula:
=RIGHT(A2,LEN(A2)-FIND(", ",A2)-1)
How this formula works
At a high level, this formula uses RIGHT to extract characters from the right side of the name. To figure out the number of characters that need to be extracted to get the first name, the formula uses the FIND function to locate the position of ", " in the name:
FIND(", ",A2) // position of Space
FIND returns the position of the comma and space as a number. This number is then subtracted from the total length of the name:
LEN(A2)-FIND(", ",A2) // length of first name + 1
The result is the length of the first name, plus one extra character, due to the comma. To get the true length, 1 is subtracted
LEN(A2)-FIND(", ",A2)-1 // length of the first name
Because the name is in reverse order (LAST, FIRST), the RIGHT function can simply extract the length of the first name.
For the example, the name is "Chang, Amy", the position of the comma is 6. So the inner formula simplifies to this:
10 - 6 - 1 = 3 // length of first name
Then,
RIGHT("Chang, Amy",3) // "Amy"
Note: this formula will only work with names in Last, First format, separated by a comma and space.
Split text into different columns with the Convert Text to Columns Wizard With a column of full names, quickly split the first and last names into separate columns. Or, if names are last name, comma, first name, reverse the order, to show first name and last name.
If you need to extract the first name from a full name in Last, First format, you can do so with a formula that uses RIGHT, LEN and FIND functions. In the generic form of the formula (above), a name is a full name in this Video.
How this formula works
Before you import a spreadsheet, make sure that contacts' first names and last names appear in separate columns. When first and last names appear in separate columns, you have more accuracy and flexibility in adding a personalized greeting to a campaign. If both first names and last names don't appear in separate columns, you can split them before importing.
~~~~Please Watch Our More Popular Video~~~~
Fuzzy lookup add in Excel│Remove Duplicate and Spelling Mistake from Fuzzy lookup
• Fuzzy lookup add in Ex...
Excel Expert Tips and Tricks -Excel Secret you don't know│cool excel tricks│best excel tips in HINDI
• Excel Expert Tips and ...
learn Vlookup excel l Vlookup true false formula l How to USE Vlookup in Excel l Vlookup excel help
• Why we Use True and Fa...
Search box in Excel, create a search box in excel with condition formatting, Excel search box-HINDI
• Search box in Excel│cr...
HOW to print Excel Document in ONE PAGE - !! workbook printing, EXCEL PRINT with Lines !! - HINDI
www.youtube.co....
How to Hide WhatsApp Videos and Images from Mobile Gallery - Nomedia Android WhatsApp Trick - HINDI
www.youtube.co....
Mobile Number Validation for 10 Digit, MS-Excel Phone Number Validation Formatting in HINDI
www.youtube.co....
How to SAVE UA-cam VIDEOS in Mobile Gallery By Changing URL (Only 3 Step)
www.youtube.co....
ＬＩＫＥ | ＣＯＭＭＥＮＴ | ＳＨＡＲＥ | ＳＵＢＳＣＲＩＢＥ
अगर आप को यह विडियो पसंद आया तो कृपया लाइक करें और अगर आप कुछ कहना या पूछना चाहते है तो कृपया नीचे दिए गए कमेंट बॉक्स में लिखें !
ComTutor हिन्दी युटूब चैनल है जो आपको इन्टरनेट, कम्प्यूटर, मोबाईल और नयी टेकनालाजी के बारे में हिन्दी में जानकारी देता है।
आप हमारे चैनल को Subscribe करे।
/ @comtutor
फेसबुक पर पसंद करने के लिए क्लिक करें
/ comtutor4u
ट्विटर पर फॉलो करने के लिए क्लिक करे
/ comtutor4u