text_analysis [MGTO]

For very simple text analysis with Excel :

Shows whether a string appears in a cell (1 - in a cell, 0 - not in a cell). Example :

=COUNTIF($B2,""&E$1&"")

will count whether $B2 includes the string in E$1, this can include wildcards like *string” or str* . (source)

Count the occurrence of a single char in a character. Example :

=LEN(A1)-LEN(SUBSTITUTE(A1,E1,""))

Count the occurrences of a string in a cell. Example :

=SUM(LEN($B2)-LEN(SUBSTITUTE($B2,""&E$1&"","")))/LEN(""&E$1&"")

will count the number of times $B2 includes the word that appears in E$1, this CANNOT include wildcards. (source)