Cleaning Up Addresses in Excel

Bob32103

New Member
Joined
Oct 7, 2018
Messages
13
I've got a data dump from a freight carrier that has columns for ship to /receipt to addresses. The issue I have is that 1 address can be listed multiple ways. For example, 123 East, 123 East St, 123 East Street. I have a list of the proper addresses. How can I go about populating the incorrect addresses with the correct address.

Thanks in advance.
 

Some videos you may like

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying

bobby_smith

Board Regular
Joined
Apr 16, 2014
Messages
80
You can copy the address from the dump onto a new tab then the use the remove duplicate feature. You will then be left with one of each address. Add the correct address name next to each address then do a Vlookup back the sheet with the original dump address.

I hope this makes sense.
 

Watch MrExcel Video

Forum statistics

Threads
1,099,044
Messages
5,466,207
Members
406,473
Latest member
Dunno123

This Week's Hot Topics

Top