This video demonstrates how to separate a name in the format: [FIRST NAME, MIDDLE INITIAL, LAST NAME] into different variables using Microsoft Excel. The LEFT, RIGHT, LEN, and FIND functions are combined to isolate the strings.
The following formulas are used:
First name =LEFT(A3,FIND(" ",A3)-1)
Middle initial =LEFT(RIGHT(A3,LEN(A3)-FIND(" ",A3)),2)
Last name =RIGHT(A12,LEN(A12)-FIND(" ",A12,FIND(" ",A12)+1))
