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 … Read More