Hey there....using MS Access, I have a field that is holding names. First field is UID, second is email address, third is names.
some names are formatted as Jack,Smith ; J.Smith, ; me@me.com
I'm only concerned with the ones that are separated by a comma. I need to break them out into two...