COUNTTEXT

Owned by Juliane Wetzel
Feb 07, 2020

Syntax

COUNTTEXT(<string>;<string>)

Description

Evaluates the substring against the column and returns the number of matches. The function is case sensitive. 

Examples

Column

Substring

 COUNTTEXT returns

Mississippi is a great state.Mississippi

1

Mississippiss2
Datameer X is making significant advances in big data analyticsdata

1

Here she hops on a horse in Hondurash3
Here she hops on a horse in HondurasH2