Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I get rid of duplicate text?
I have a database of addresses that contain duplicates. Example is 12 ball
st., and 12 ball street. I need to delete these if they are the same. thanks |
#2
|
|||
|
|||
The bad news is that st. and street may be the same to you, but they're not the
same to a mechanical routine (like a worksheet function or VBA code). I think if I had to do this, I'd try to cleanse the data first. And that could take a lot of time. DMCunningham wrote: I have a database of addresses that contain duplicates. Example is 12 ball st., and 12 ball street. I need to delete these if they are the same. thanks -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Finding Duplicate text strings with a single column | Excel Worksheet Functions | |||
In Excel, how do I get rid of duplicate records? Based on text r. | Excel Discussion (Misc queries) | |||
Autofitting a row | Excel Discussion (Misc queries) | |||
Sort or Filter option? | Excel Worksheet Functions | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) |