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