Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
=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 |
#3
|
|||
|
|||
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 . |
#4
|
|||
|
|||
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 . |
#5
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting specific text in a cell | Excel Worksheet Functions | |||
counting instances of words in a worksheet cell | Excel Discussion (Misc queries) | |||
Counting instances in a cell | Excel Discussion (Misc queries) | |||
Counting In a Cell | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |