+ Reply to Thread
Results 1 to 10 of 10

fix the cities in addresses

  1. #1
    Forum Contributor
    Join Date
    11-24-2016
    Location
    Libya
    MS-Off Ver
    Office 365
    Posts
    526

    fix the cities in addresses

    Hello excel experts

    as a short sample…… these would be ideal address to fix, all should be address, apt#, city, state, zip code
    can the city in column be used instead of the city that is already there, because it (the city in column c) has a lot of human errors
    but the city in column J is not by humans so it is correct
    can we somehow extract the apt# for the address
    Attached Files Attached Files
    Last edited by KingTamo; 03-02-2018 at 12:46 PM.

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,164

    Re: fix the cities in addresses

    Hello KingTamo,

    It sounds like you need a Fuzzy Logic tool for Excel. It will correct misspellings if they are close enough.

    https://www.microsoft.com/en-us/down....aspx?id=15011
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  3. #3
    Forum Contributor
    Join Date
    11-24-2016
    Location
    Libya
    MS-Off Ver
    Office 365
    Posts
    526

    Re: fix the cities in addresses

    I have downloaded this program addin but couldn't use it. Would I get a macro for splitting the parts of the address into small segments?

  4. #4
    Valued Forum Contributor
    Join Date
    11-28-2015
    Location
    indo
    MS-Off Ver
    2016 64 bitt
    Posts
    1,241

    Re: fix the cities in addresses

    not perpect but you can edit
    Please Login or Register  to view this content.
    "ThankyouFor Attention * And Your Help!!"

  5. #5
    Forum Contributor
    Join Date
    11-24-2016
    Location
    Libya
    MS-Off Ver
    Office 365
    Posts
    526

    Re: fix the cities in addresses

    thank you so much daboho
    Can I get each part of the address in separate column ?

  6. #6
    Valued Forum Contributor
    Join Date
    11-28-2015
    Location
    indo
    MS-Off Ver
    2016 64 bitt
    Posts
    1,241

    Re: fix the cities in addresses

    not understand you mean but i am only
    follow your should be in column(k)

  7. #7
    Forum Contributor
    Join Date
    11-24-2016
    Location
    Libya
    MS-Off Ver
    Office 365
    Posts
    526

    Re: fix the cities in addresses

    I mean "1 DEERCREST LN INDIAN HD PK IL 605254432" to be in different columns
    "1 DEERCREST LN" in column
    "INDIAN HD PK" in column
    "IL" in column
    "605254432" in column

  8. #8
    Valued Forum Contributor
    Join Date
    11-28-2015
    Location
    indo
    MS-Off Ver
    2016 64 bitt
    Posts
    1,241

    Re: fix the cities in addresses

    TRY this
    Please Login or Register  to view this content.
    Last edited by daboho; 03-03-2018 at 02:55 PM.

  9. #9
    Forum Contributor
    Join Date
    11-24-2016
    Location
    Libya
    MS-Off Ver
    Office 365
    Posts
    526

    Re: fix the cities in addresses

    Yes that's working very well
    thanks a lot for this working code. thanks a million

  10. #10
    Valued Forum Contributor
    Join Date
    11-28-2015
    Location
    indo
    MS-Off Ver
    2016 64 bitt
    Posts
    1,241

    Re: fix the cities in addresses

    you are welcome
    dont forget to treat as solved
    Last edited by daboho; 03-03-2018 at 02:54 PM.

+ 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. How to get the counts for different cities in a certain period.
    By rvfotopro in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-14-2017, 03:55 PM
  2. counting cities
    By TheVolkinator in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-26-2014, 02:35 PM
  3. Filterin of Cities in addresses
    By btiongsonjr in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-13-2013, 10:04 PM
  4. Macro to filter cities
    By rafuk73 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-31-2013, 09:56 AM
  5. Replies: 2
    Last Post: 10-19-2012, 12:23 PM
  6. Replies: 3
    Last Post: 05-28-2012, 03:52 PM
  7. Many Cities into few Regions
    By Johnny Image in forum Excel General
    Replies: 2
    Last Post: 04-17-2012, 07:25 PM

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