How to Split First Name and Last Name using LEFT and RIGHT Functions
Microsoft Excel Text Functions LEFT and RIGHT allows you to split the first name and last name in a text string (words and sentences). With a combination of LEFT, FIND, RIGHT and LEN Functions, Excel intelligently extracts text you specify based on the number of characters you specify.