Separating Last Name, First Name into Two Fields

S

Scott

Hello,

I have a table with a single field entitled "Name" that follows the format
"Last Name, First Name." I'd like a way to separate the data so that I have
one field with "Last Name" and another field with "First Name" with no comma
in either field.

Any ideas?

I appreciate your help.

Scott
 
Top