TEXTCOMPARE

Compares two texts and returns -1, 0, or 1.

Origin: A deepcalc original
Excel: No equivalent
Google Sheets: No equivalent
Returns: Text

Examples

=TEXTCOMPARE("apple", "banana")

Result -1

=TEXTCOMPARE(A1, B1, FALSE)

	A	B
1	10	2

Result -1

Syntax

TEXTCOMPARE(text1, text2, [case_sensitive])

text1: text required
text2: text required
case_sensitive: boolean optional

ASCConverts full-width characters to half-width. BAHTTEXTSpells a number as thai baht and satang. CHARReturns the character for a character-set code. CLEANRemoves non-printable characters. CODENumeric code of the first character. CONCATJoins multiple text strings into one.