Excel Tips & Tricks: Split Names with LEFT, MID & RIGHT Functions / Quick Data Entry #shorts #excel

In this video, we will learn how to split a full name into first name, middle name and last name using the LEFT, MID, and RIGHT functions in Excel.
Helpful for those who are searching for Data entry and data Cleaning Jobs.

Step 1: Enter the Full Name
Enter the full name you want to split into cell B Column

Step 2: Extract the First Name Using LEFT and FIND
Select cell C3 where we want to display the first name.
Enter the formula to extract the first name:
=LEFT(B3,FIND(" ",B3)-1)

Press Enter. The first name should appear in cell C3.

Step 3: Extract the Middle Name Using MID and Find.

Select cell D3, where we want to display the middle name.
Enter the formula to extract the middle name:
=MID(B3,FIND(" ",B3)+1,FIND(" ", B3,FIND(" ",B3)+1)-FIND(" ",B3))

Press Enter. The middle name should appear in cell D3.

Step 4: Extract the Last Name Using RIGHT, FIND, and LEN

Select cell E3, where we want to display the last name.
Enter the formula to extract the last name:
=RIGHT(B3,LEN(B3)-FIND(" ",B3,FIND(" ",B3)+1))

Press Enter. The last name should appear in cell E3.

Thanks for watching, and don't forget to subscribe for more Excel tips and tricks! @TechTableTutor
One-click on the subscribe button makes me feel more motivated.
If you found this video helpful, please give it a thumbs up and leave a comment below.
#excel #msoffice #msexcel #exceltutorial #excelfunctions #excelacademy #excelgyan #exceltech #excellearning #exceltips #exceltricks #tipsandtricks #tips #tricks #excelpro #advancexcel

Видео Excel Tips & Tricks: Split Names with LEFT, MID & RIGHT Functions / Quick Data Entry #shorts #excel канала Tech Table Tutor