Counting keystrokes within a cell

C

Connie Martin

Is there a formula which would count the number of keystrokes in a singular
cell? If this is typed in a cell: 4660TBGBW CB then the formula would
yield 12 because the space is also a keystroke.

Thank you
Connie Martin
 
B

Biff

Hi!

=LEN(A1)

This will count the number of chars in a cell AFTER they
have been entered. If want to count "as you type", it
can't be done.

Biff
 
C

Connie Martin

Thank you so much!

Biff said:
Hi!

=LEN(A1)

This will count the number of chars in a cell AFTER they
have been entered. If want to count "as you type", it
can't be done.

Biff
Click to expand...
 
Top