String - StrComp
=StrComp(String1 , String2 ,
Optional Compare )
Returns the result of a string comparison.
String1, String2 : strings to be compared
Compare : Optional.
Constant to specify how the strings are being compared. 0 indicates a
binary comparison and 1 specifies a text comparison.
A return value of 0 indicates that both strings are equal. A return
value of -1 indicates that string1 is less than string2. A return value of
+1 indicates that string1 is larger than string2.
Find out if two words contain
the same text but ignore differences in upper and lower
=StrComp("Hello World","hello world",1)