Substring count in single cell

[babuInba]

Hi Everyone,

i'm looking for solution to count number of specific text in a string. 

Example  i have value as "123e23,2455e2334e" i would like to count number "e" in this string.

Thanks in advance.

[Anonymous · Accepted solution]

Hi @babuInba 

For your simple sample, you can do 

Text.Length(Text.Select([Column1],"e"))