Excel Data Processing Formulas

1.

Extract First Name from First & Surname Field

Example: Cell A1 is “John Doe”

Formula: Cell B1 =LEFT(A1,SEARCH(” “,A1,1))

Result: John

2.

Extra Last Name from First & Surname Field

Example: Cell A1 is “John Doe”

Formula: Cell B1 =RIGHT(A3,(LEN(A3)-SEARCH(” “,A3,1)))

Result: Doe

3.