+ Reply to Thread
Results 1 to 7 of 7

Large Excel Data Base With Street Names that might End in Dr or Blvd or St

  1. #1
    Forum Contributor
    Join Date
    03-06-2015
    Location
    houston, tx
    MS-Off Ver
    MS 365
    Posts
    490

    Large Excel Data Base With Street Names that might End in Dr or Blvd or St

    I have large data base with street names and street addresses that I have been going through manually to put the correct ending to a
    Street Name. Example: Fairview should either be Fairview or Vairview Blvd, depending on address. Or Manor could be Manor Dr or Manor St depending on street address. There are so many variations that I have not been able to find an excel formula to correct.

    I do have a city wide Street Index and Street Address data base that is correct. I am attaching a sample of the database that needs correcting and the Street Index that is correct.

    Is there a way to do this using formulas?

    Thanks
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    02-14-2017
    Location
    India
    MS-Off Ver
    2013
    Posts
    128

    Re: Large Excel Data Base With Street Names that might End in Dr or Blvd or St

    First create a find and replace list based on street address. then use find and replace macro.
    Manikandan Arumugam
    Excel Learner

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Large Excel Data Base With Street Names that might End in Dr or Blvd or St

    Quote Originally Posted by Manikandan Arumugam View Post
    First create a find and replace list based on street address. then use find and replace macro.
    Depending on the OP's skill level, that may or may not be a meaningless suggestion for them. Rather, give some instructions on how to do what you suggested, that way, they can understand what you are saying

    We get members from all levels of skill in here, and it is a potential mistake to assume what a member's proficiency level is.

    Also, changing street names is probably no an option
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Large Excel Data Base With Street Names that might End in Dr or Blvd or St

    pick44, which sheet do you want the corrections on?
    can you show some sample answers, and explain how you got them?

  5. #5
    Forum Contributor
    Join Date
    03-06-2015
    Location
    houston, tx
    MS-Off Ver
    MS 365
    Posts
    490

    Re: Large Excel Data Base With Street Names that might End in Dr or Blvd or St

    I have attached a sample of the Correct Street Index, the Unmatched Street Name with Address, and the column which would be the Street Name and Address
    match that should be found.
    Yellow highlight is Good Street Index
    Blue highlight is the file I am working with
    Orange highlight is the correct street name associated with the Street Index file.
    Attached Files Attached Files

  6. #6
    Forum Contributor
    Join Date
    02-14-2017
    Location
    India
    MS-Off Ver
    2013
    Posts
    128

    Re: Large Excel Data Base With Street Names that might End in Dr or Blvd or St

    Sure FDibbins. Will follow it in future.

  7. #7
    Forum Contributor
    Join Date
    03-06-2015
    Location
    houston, tx
    MS-Off Ver
    MS 365
    Posts
    490

    Re: Large Excel Data Base With Street Names that might End in Dr or Blvd or St

    I have complete my task by doing it manually. Whew. So I guess this thread should say Solved.

+ 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. [SOLVED] Find or Match and Replace-large data base
    By kunjanee in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-28-2017, 02:42 AM
  2. Need to pull address ranges with accompanying data for large data base
    By pick44 in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 03-09-2015, 11:12 AM
  3. [SOLVED] Want to separate unique and duplicate data from large data base
    By sambha in forum Excel Programming / VBA / Macros
    Replies: 39
    Last Post: 08-02-2014, 12:30 AM
  4. Help Creating a List from a large data base with repeating information
    By KelliB in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-17-2013, 04:09 PM
  5. Extract Street Names from Addresses
    By makaza in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-12-2007, 05:25 AM
  6. [SOLVED] How do you move names and data between large Excel 2003 workbooks?
    By shore in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-22-2005, 08:05 AM
  7. Import data from files with different names to EXCEL D'base.
    By thunderfoot in forum Excel General
    Replies: 2
    Last Post: 06-10-2005, 06:05 AM

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