How do I get rid of duplicate text?

G

Guest

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
 
D

Dave Peterson

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to sort addresses in microsoft excel 2
Need assistance with how or even if this is possible (function) 8
Highlite Duplicates in 2 Columns (Conditional Formating) 3
count function 7
how do I look for duplicate house addresses in a column in Excel? 3
Merging duplicate entries in Excel or deleting the duplicates (Exc 1
Relpace entire address with street name only, searching with wildc 3
MID, LEFT, RIGHT help 5

Top