Matching Address Columns

[pw034]

I am looking for a way to identify a match when comparing columns, which contain address information.

Example:

Column A contains: 123 South Main Street
Column B contains: 123 S. Main St.

Same address, but I am looking for a way that Excel can identify the match.

Any help would be great!

Thank you in advance

[oldchippy]

How about using the Data > Sort A-Z on column A, then do the same on column B, would that help?

[pw034]

I have tried that, but no luck. The list that I am dealing with has thousands of addresses and may not be exactly matched row for row.

Thank you for the suggestion though

[oldchippy]

I can't see an easy way to do what you want, but another suggestion would be to do a Find > Replace, "Main St." to "Main Street". Then you are getting closer to find your matches.

Don't just do a Find > Replace on "St." because a "St." (Saint) could become a Street - God forbid!

[pw034]

lol...thanks for your help