View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Rbryant Rbryant is offline
external usenet poster
 
Posts: 1
Default Duplicate records with various formats for fields

Is there a why to delete duplicates where record fields have different
formats. For example, a record that hass name as Mr. J. Jones will be
different to John Johns, or the address can have S. HWY instead of South
Highway. If there an easy way of deleting these records as duplicates
although the format may not be 100% the same?