+ Reply to Thread
Results 1 to 5 of 5

How to validate a Physical address that is contained in one single cell

  1. #1
    Registered User
    Join Date
    06-26-2019
    Location
    georgia
    MS-Off Ver
    o365
    Posts
    9

    How to validate a Physical address that is contained in one single cell

    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?
    Attached Files Attached Files
    Last edited by bellerb; 05-25-2022 at 02:39 PM.

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,810

    Re: How to validate a Physical address that is contained in one single cell

    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

  3. #3
    Registered User
    Join Date
    06-26-2019
    Location
    georgia
    MS-Off Ver
    o365
    Posts
    9

    Re: How to validate a Physical address that is contained in one single cell

    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"

  4. #4
    Forum Expert
    Join Date
    09-30-2019
    Location
    Chiangmai, Thailand
    MS-Off Ver
    Office 2016, Excel 2019
    Posts
    1,234

    Re: How to validate a Physical address that is contained in one single cell

    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.

  5. #5
    Registered User
    Join Date
    06-26-2019
    Location
    georgia
    MS-Off Ver
    o365
    Posts
    9

    Re: How to validate a Physical address that is contained in one single cell

    Quote Originally Posted by alansidman View Post
    What do you mean by Validated?
    Any ideas on how to do this?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 11
    Last Post: 03-01-2019, 01:17 PM
  2. Match incomplete or mixed street/physical Address to a clean address format
    By vivek.budhram in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-21-2018, 03:31 PM
  3. [SOLVED] List Physical Cell Address based on Non-Match to Specific Data
    By liquidmettle in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 12-18-2017, 05:22 PM
  4. Replies: 4
    Last Post: 10-07-2013, 01:33 PM
  5. Separating physical from mailing address
    By nander in forum Excel General
    Replies: 3
    Last Post: 04-19-2011, 01:44 AM
  6. To refer to a cell whose address is contained in a cell in another sheet.
    By kmlprtsngh in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-15-2010, 03:32 AM
  7. Replies: 5
    Last Post: 03-10-2005, 08:06 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1