View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David David is offline
external usenet poster
 
Posts: 1,560
Default Comparing similar but inexact text

Is there a function to compare text values that are similar but inexact
matches to evalute their similarity? For example if I compare "ALBERTSON'S"
to "ALBERTSONS" the two won't match but I would like to flag them as a close
match. This would be similar to when you enter a typo in a search engine and
it suggests alternate spellings.