The large database has addresses that someone must have tried to correct. But it just made a mess. There are some addresses with lots of space between the street name and some have double endings like XYZ RD RD instead of XYZ Rd, etc.
Help would be appreciated.
Enter formula in B2 and copy down
Formula:
Please Login or Register to view this content.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks