Can anyone help me to write three functions in vba access in order to extract the name like the examples below into last name, first name and MI?
the format of the name is "First Name", "MI", "Last Name" and "Suffix".
however, if there is no "MI", the MI part will be missing.
CREE L SHUMPERT
JOSE G. HERNANDEZ JR
CHEYENNE A CORRAL
one of the name is "JOSE G. HERNANDEZ JR"
lastname(name) = "Hernandez"
firstname(name) = "Jose"
MI(name) = "G"