ParsingName
I am using Access 97. There is a column in the spreadsheet that has
names in it Smith. Jeff Sr A the last name is followed by a period. I
want to copy the Lastname , without the ., firtsname, and middle initial
, with a . to seperate columns.
Col 4 Col5 Col6
Smith Jeff A.
Is there a function avaliable for this?
TIA
|