LENGTH + SUBSTITUTE for Word Count

1

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)-Length(Substitute(thisRow.Notes, " “,”"))+1

Thanks

2

@Tim_Sherrod

I use @Murray_Adcock’s regex for word count, discussed here: Word Count - Word Processing Features

3

Works perfectly. Thanks so much.

1 Like