Counting keystrokes within a cell
 

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

=LEN(A1)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Connie Martin" wrote in message
...
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

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

-----Original Message-----
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
.

Thank you so much!

"Biff" wrote:

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

-----Original Message-----
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
.

Thank you very much!

"Bob Phillips" wrote:

=LEN(A1)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Connie Martin" wrote in message
...
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