I have an excel spreadsheet with the names column formatting with examples as follows:
JOHN SMITH - stays as JOHN SMITH
JOHN A DOE - becomes JOHN DOE
MARY ALLEN JOHNSON - becomes MARY JOHNSON
I am hoping to get just the first and last names, so I want to count, by counting forward (first name) till the space occurs and backward (last name) till the first space occurs.
Basically, the space is the defining separator for creating the columns of first and last name.
Hope this makes sense.