Description: 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.
Example: Find out if two words contain
the same text but ignore differences in upper and lower
case. =StrComp("Hello World","hello world",1)
Copyright (C) 1995-2014 Linker IT
Software BV. All Rights Reserved. Oracle is a registered trademark of
Oracle corporation. Excel and Office are registered trademarks of
Microsoft corporation. Other names appearing on the site may be trademarks
of their respective owners. Software,
files, documents, articles and other material are provided
"as is" and without warranties as to performance or mechantability or
any other warranties whether expressed or implied. No
warranty of fitness for a particular purpose is offered.