I have two tables that I need to relate. I figure I can do this by displaying the tables side by side (or in excel) alphabetically.
Problem:
One table has the name field listed as "Last Name, First name".
The other table is "First Name Last Name" (no commas).
I figure I can make them the same if I can separate one of those fields and put it back together in the same format as the other.
Say I separate the "Last Name, First Name" into "Last Name" and "First Name". Then I can put them together as "First Name Last Name"
Thank you for your help!