I am trying to count words in a cell using the LENGTH and SUBSTITUTE formula but it doesn’t seem to want to recognize the difference between " " and “”. This formula only works if if can replace the spaces since that is what it counts. Any ideas of how to get that to work? Length(thisRow.Notes)-Len…

Works perfectly. Thanks so much.

LENGTH + SUBSTITUTE for Word Count

Ander February 7, 2020, 2:53pm 2

Topic		Replies	Views
How to count characters in a cell? Ask the Community	2	924	January 31, 2023
RegexReplace whitespace between text or word Ask the Community	3	770	October 28, 2022
Formula help to count specific characters? Ask the Community	3	1012	July 1, 2021
Count occurrences within specific cell Ask the Community	5	581	January 27, 2023
Feature Request: A new string operator – Trunc Ask the Community	10	1480	February 4, 2020