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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Separating Last Name, First Name into Two Fields 4
Grouping Names in Mail Merge 0
Template with fields and premade texts.. 0
MS Project Center-Autolink column fields 0
Insert name and adress from a list in a word document 1
Dynamic Naming of Form Button 3
VBA - exporting serial letters to single documents 0
Switch Last Name First Name to First Name Last Name 2

Top