View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Heera Chavan[_2_] Heera Chavan[_2_] is offline
external usenet poster
 
Posts: 18
Default Find similar items from a two fields.

Hi,

I am really in a tight spot now.

I need macro which will compare two strings if they are similar.

For example:
StringA = I-11524A
StringB = I-11525B
StringC = I-11525

Now these three string are similar and need a utility which will compare
these strings and highlight them if they are similar.
I tried two three codes like StrComp(str1, str2, vbTextCompare) but it did
not work.

Kindly help.

Regards
Heera Chavan