String Functions

[JL]

The function "instr" will find character in a string.
To answer your question,

lastname = Trim(Mid(FullName, 1, InStr(FullName, ",") - 1))
firstname = Trim(Mid(FullName, InStr(FullName, ",") + 1))

Hope this will help.