CONTAINS

Checks if text contains substring.

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

Examples

=CONTAINS("hello world", "world")

Result true

=CONTAINS(A1, "test")

	A
1	10

Result false

Syntax

CONTAINS(text, substring)

text: text required
substring: text required

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.