Hi,
Would anyone know if there are any expressions that can help me count the amount of times a character appears in a cell?
For example:
I would like to count the amount of times a โ/โ appeared in the text below,
000123456/000257446/000344646
the answer would = 2
Thanks in advance,
Chris
You could combine SPLIT() and COUNT() to create a list and count the values. It gets a little tricky though because you have to test for the character being at the beginning or end.
I would sayโฆ COUNT(SPLIT([Column],"/"))-1
Thanks guys, got the outcome required.
User | Count |
---|---|
40 | |
32 | |
30 | |
16 | |
16 |