Linker IT Software
Order Home
menubar-top-links menubar-top-rechts
SQL*XL: Database to Excel bridge ExcelLock: Lock and secure your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe
Home Products litLIB Help String functions

Buy now

Download now

LITlib - Excel Power Functions Pack
 
Add-in for Excel that adds additional cell functions to Excel.

litLIB Help - StrComp function
litLIB Help
Product pages :
litLIB
Quick links:
help index
forums

String - StrComp

Syntax:
=StrComp(String1 , String2 , Optional Compare )

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)

litLIB