Re: Formula for Character-Count

3431 0
Showing results for 
Search instead for 
Did you mean: 

Has anyone worked out how to use the COUNT function to count the number of characters in a text string?

27 Replies 27

Nice! How’s this working?

Thank you, Peter - that sounds like it will fill the bill perfectly! I will have to try that after clearing out my post-holiday work pile up!

Works as desired! I give up being able to average the number of states since it is now text instead of a number, but that is an easy ‘price’ to pay. Thanks again, Peter!

Oh, no trouble at all Kat, it was a fun challenge to work out :slightly_smiling_face:

4 - Data Explorer
4 - Data Explorer

Hi guys, Do you know how could I count words, instead of characters?

@Diogo_Nogueira - I don’t know of a ‘simple’ solution, but here’s a workaround.

If NOTES is the name of the field you are trying to count words for, try:

LEN(Notes)-LEN(SUBSTITUTE(Notes," “,”"))+1

LEN(Notes) will count the total characters

SUBSTITUTE(Notes," “,”") will remove the spaces from Notes. Wrapping that in LEN will then count the characters in Notes without spaces.

Then we need to add one (1) to this, since the last word won’t have a space after it.

Be aware that if you use a space in the field you are counting, it will effectively tell this formula that there is a separate word.

Hope this helps! :slightly_smiling_face:

Nice workaround Gareth,

To further prevent user error though, I would suggest to TRIM Notes to eliminate any leading and trailing spaces.

Kind regards,


Thanks Gareth! I already found a solution! :grinning:

4 - Data Explorer
4 - Data Explorer

Does anyone know how to make a word count formula?