I'm trying to separate first and last name in a column into two columns. Seems like there should be a simple query expression for this. Does anyone know what that would be? The field is currently formatted as:
Doe, John (one column)
Need "Doe" in column 1 and "John" in column 2.
Thank you...
Doe, John (one column)
Need "Doe" in column 1 and "John" in column 2.
Thank you...