count characters/spaces
I want to count how many characters is there a cell
As well how many spaces
2 separate formulas, or combined the characters - the spaces
Question marked as
Best reply
This should give you some ideas of how to count characters and spaces in the text in cell A1:
This is a test sentence | Result | Formula |
Number of characters | 23 | =LEN(A1) |
Number of non spaces | 19 | =LEN(SUBSTITUTE(A1," ","")) |
Number of spaces | 4 | =LEN(A1)−LEN(SUBSTITUTE(A1," ","")) |
SG