TEXTCOUNT

Counts occurrences of substring in text.

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

Examples

=TEXTCOUNT("hello hello world", "hello")

Result 2

=TEXTCOUNT(A1, "test", FALSE)

	A
1	10

Result 0

Syntax

TEXTCOUNT(text, substring, [case_sensitive])

text: text required
substring: 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.