View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
lkl lkl is offline
external usenet poster
 
Posts: 1
Default Searching for data in an array.

Can anyone tell me how to do this with TEXT...that is text that is close but
not a perfect match? For example f I see MR and MR. I want them to be called
a match, even tho one does not ahve the period (or extra spaces or Jr, etc).
Having lots of trouble with this.