Excel Expert
Budget: $30 – $250 USD
I have a very large database. In the first column I have an Owner's name for a certain property. The problem is that Owner's name is Last name first then first name, followed by a second person on title with their last name first. Example:
COLLINS JASON D & KANDACE R
I would like this to read JASON D & KANDACE R COLLINS
KISH JOHN M & JOAN D KISH H&W
I would like this to read JOHN M & JOAN D KISH
I'm not sure if there is a function that I can put into the file that would do this? I have many files I need to make these changes on.
COLLINS JASON D & KANDACE R
I would like this to read JASON D & KANDACE R COLLINS
KISH JOHN M & JOAN D KISH H&W
I would like this to read JOHN M & JOAN D KISH
I'm not sure if there is a function that I can put into the file that would do this? I have many files I need to make these changes on.