I have a long list of address that need to be validated and all formatted the same. Currently i am copy/pasting into google address search but that would take forever. Any ideas on how to do this with a formula?
I have a long list of address that need to be validated and all formatted the same. Currently i am copy/pasting into google address search but that would take forever. Any ideas on how to do this with a formula?
Last edited by bellerb; 05-25-2022 at 02:39 PM.
What do you mean by Validated?
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
So i would like for it to be "validated" as if i was shipping something to that address. I can do this on UPS website but its singles and i have 2800 rows to "validate"
If I'm not wrong, you want to verify the address in worksheet with address in the real world (via google map or something alike).
You might be need VBA (I don't know much about VBA) to archive this (and you may need google map api also).
Regards.
My English is very poor, so please be patient >_<"
My Dynamic Related Dropdown post:
https://www.excelforum.com/excel-for...ml#post5657376
https://www.excelforum.com/excel-for...ml#post5655711
https://www.excelforum.com/excel-for...ml#post5655762
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks