Thread: Compare Values
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Wiz Wiz is offline
external usenet poster
 
Posts: 4
Default Compare Values

I need to compare the value of a cell to the values in a range of cells.
Problem is, these alpha-numeric values may have spaces and/or dashes, which
need to be ignored. Example- ab-uty should find abuty, a buty, and a-b uty as
duplicates. I have tried to use the substititute function to clear the
dashes and spaces, which works well for the compare cell, but will not work
on the range. Am I outta luck here?