How To Split Full Name To First And Middle and Last Name In Excel?

We are doing a lot of work with management information system in the office and marketing software and Shop, Mall, Medical, MNC Company Customers often give us data that’s not easily used and we need to use formulas to fix any issues.

 

It is a common problem is the full name is in the data in a single excel column. If we wanna to use a Firstname” acknowledgement we need to split that and we can easy to do. You may use the Left function Middle function, Right function and Find function to spit a full name to the first name and last name with following steps.

1.) Fist step for Left function example to split name.

Example :- =LEFT(G3,FIND(" ",G3)-1)  Enter

 

2.) Second Step for MID Function example to split name from cell range see deeply below screen shot and understand.

Example :- =MID(C3,FIND(" ",C3,1)+1,FIND(" ",C3,FIND(" ",C3,1)+1)-FIND(" ",C3,1)) Enter

 

3.) Third step for RIGHT Function example to split name from cell range see deeply below screen shot and understand.

Example :- =RIGHT(C3,LEN(C3)-FIND(" ",C3,FIND(" ",C3,1)+1)) Enter

4. Very very easy formula to split text First ,Middle and Last .....below screen shot most important function to split full name see deeply and understand.

Example:- 

 Below YouTube video for better understand to split text 

                                    👇