Excel partial match (remove duplicates from list)

[Nik123]

Does anyone know how to ask Excel to make a fuzzy match? I'm looking for it to see 123 E. Pikes Peak Ave. and recognize that might be 123 East Pikes Peak Ave. or 123 E. Pikes Peak Avenue. I'd settle for figuring out how to ask excel to simply check based on only the first 3 caraters in the cell (which in most cases would be street number). I'm trying to remove duplicates from a list. So I'd like for Excel to alert me to these fuzzy matches by changing colors with conditional formatting, or someting along those lines. (I'm using Excel 2003) I do not want it to delete the duplicate. THANKS!!

 

[VoG]

Take a look here http://www.mrexcel.com/forum/showthread.php?p=955137#974873