Split full names to first, middle and last names: Then enter the formula of =RIGHT(A2,LEN(A2)-FIND(" ",A2,1)) in another blank cell, Cell D2, and drag the fill handle down to the cells which you want to apply this formula, and all last names have been extracted in column D as following screenshot shown: Enter the formula of =LEFT(A2,FIND(" ",A2,1)-1) in a blank cell, says Cell C2 in this case, and then drag the fill handle down to the cells which you want to fill this formula, and all first names have been extracted at once, see screenshot:Ģ. You can use the Left function, Right function and Find function to spit a full name to the first name and last name with following steps:ġ. Split full names to first and last names: Split full names to first and last names by comma or other delimiters ![]() ![]() Split full name to first and last name with Kutools for Excel quickly Split full name to first and last name with Text to Column command ![]() Split full name to first and last name with formulas
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |