How do I "split" first name/last name into two separate files?
Can someone please tell me how to separate or split the data in FIRST NAME into First Name and Last Name fields?
For example, I just imported a HUGE database, and the names are all like this: JIM SMITH, and "JIM SMITH" is all in ONE field. However, I want JIM as a First Name, and SMITH as a Last Name field.
So, how do I split this?