pankajgrover
Board Regular
- Joined
- Oct 27, 2022
- Messages
- 99
- Office Version
- 365
- Platform
- Windows
here is screenshot attached. in Q5 i am trying to count words of C5, but when i drag fill it counts also blank value and fill 1 value . how to do put value as blank in Q5.
I am using this =LEN(TRIM(C5))-LEN(SUBSTITUTE(C5," ",""))+1 but it gives blank column value as 1 instead of blank. Thanks.
I am using this =LEN(TRIM(C5))-LEN(SUBSTITUTE(C5," ",""))+1 but it gives blank column value as 1 instead of blank. Thanks.