I have one name field, that goes from left to right, with
First Name_Middle Entity (if any)_Last Name
where the _ are spaces
Here are some examples of Column A:
Mary J Williams
Mary Johnson Williams
In all cases, I want to separate only the first and last names out into two separate fields, and disregard the middle initial, so the result will be:
Column B - Mary
Column C - Williams
First Name: Left([Full Name],InStr([Full Name]," ")-1)
works for the First Name field.
However, the forumla:
Last Name:Right([Full Name],Instr([Full Name]," ")+1)
does not work for the Last Name field.