I know how to use the LEN formula to count WORDS in a cell...but is there a way to manipulate the formula to count CHARACTERS in a cell?
Here's the formula I'm using now:
=IF(LEN(TRIM(F1))=0,0,LEN(TRIM(F1))-LEN(SUBSTITUTE(F1," ",""))+1)
F1 is the cell that contains the text I'm working with.
Thanks in advance for your help!
Here's the formula I'm using now:
=IF(LEN(TRIM(F1))=0,0,LEN(TRIM(F1))-LEN(SUBSTITUTE(F1," ",""))+1)
F1 is the cell that contains the text I'm working with.
Thanks in advance for your help!