Forum Discussion

Wkeith's avatar
Wkeith
Icon for Helper II rankHelper II
7 years ago
Solved

Count of Text Strings in A Specific Cell

Hi, I am trying to count the number of times the character "-" appears in each cell for a column in my table. I want this measure to be in the calculated column format. Here is my expected result:  ...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    7 years ago

    Hi,

    Try this calculated column formula

    =len(Data[Phrase])-LEN(SUBSTITUTE(Data[Phrase],"-",""))

    Hope this helps.

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
7 years ago

Hi,

Try this calculated column formula

=len(Data[Phrase])-LEN(SUBSTITUTE(Data[Phrase],"-",""))

Hope this helps.