Separate First Name, Middle Initial, and Last Name into Different Variables using Excel
72.8 هزار بار بازدید -
7 سال پیش
-
This video demonstrates how to
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))
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))
7 سال پیش
در تاریخ 1396/06/28 منتشر شده
است.
72,837
بـار بازدید شده