Need to separate text into two fields. How?
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, Firs...
Forum Discussion
not tested but try this formula to calculate the result in the format John Smith.
List(" ",
Trim(right([last name. first name field],",")),
Trim(left([last name. first name field],",")))
List(" ",
Trim(right([last name. first name field],",")),
Trim(left([last name. first name field],",")))
Thank you for this reply.
Do you have a way to reverse the process?
Take a [first name Last Name] and make it [Last Name, First Name]?
thank you
Do you have a way to reverse the process?
Take a [first name Last Name] and make it [Last Name, First Name]?
thank you