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…

LENGTH + SUBSTITUTE for Word Count

Ander February 7, 2020, 2:53pm 2

Topic		Replies	Views
Count Words Used in text	4	455	March 3, 2023
How to count characters in a cell?	3	775	January 31, 2023
Need help with a formula	3	418	April 19, 2023
RegexReplace whitespace between text or word	4	657	October 28, 2022
Match text from one column with list from another table	10	1729	September 3, 2020