arnelgp: Your solution produce the right result, however when I changed to the following
KnownAs2: Left$([FirstName2] & " ",InStr(1,[FirstName2] & " "," ")-1) the result is blank
The only change is the addition of the numeral 2.
The first name is required for a salutation eg. Dear John...