Use the formula =len(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)