Count Characters with space in a cell
=len(a1)
will return the count of all characters in A1
=len(substitute(a1," ","")
will count the number of non-spaces in A1
and
=len(a1)-len(substitute(a1," ",""))
will count the number of spaces in A1.
NH wrote:
Please help...is it a way to count characters with space in a cell?
Examples:
Cell A1: Apple and oranges == 17 characters (with spaces); 15 characters
(with no spaces)
Cell A2: Pineapple == 9 characters (with and with no spaces)
--
Dave Peterson
|