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
Bookmarks