How Do I remove all text on the left side of a comma and remove comma too.
I have a field titled "Name" that currently has a Last name, First Name format in field. Database was created from an export from an accounting program that had Last and First names combined. I have managed to properly seperate the Last name. However, I have been unable to seperate the first names without having some of the name missing. First names sometimes include Mr. & Mrs. ,John T.,Sarah Sally for example. I want to include everything to the right of the comma but do not want the comma. I have already created a new field called First Name that is currently blank.