Est. Budget: $25.00
Cleaning up Excel data base for inconsistencies, formatting issues in order to be imported into Access (want to work with Remote Desktop)
You are going to guide me (giving suggestions and guidence) on how to clean up Excel database for example, Addresses are inconsistent, P.o box, P.O. Box, Rd or road. I did many of them using search and replace.
Another example, splitting names into first name, last name and middle names.
Middle has both short from and ...