Counting Characters

[Chris_Jeal]

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

[GreenFlux]

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.

[Aleksi]

I would say… COUNT(SPLIT([Column],"/"))-1

[Chris_Jeal]

@GreenFlux @Aleksi

Thanks guys, got the outcome required.