T
tracktor
I need a formula that keeps a running count of characters in a cell.
Any help would be appreciated
Any help would be appreciated
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Dave Peterson
You can use a formula like:
=len(a1)
to return the number of characters in A1. But the formula will only update
after the user finishes making a change to A1.
=len(a1)
to return the number of characters in A1. But the formula will only update
after the user finishes making a change to A1.
J
jlclyde
I need a formula that keeps a running count of characters in a cell.
Any help would be appreciated
=Len(A1) this will give the count of all characters in A1. Remeber
this includes sapces.
Jay
P
Pete_UK
The LEN function does this, as in:
=LEN(A1)
Hope this helps.
Pete
=LEN(A1)
Hope this helps.
Pete
T
tracktor
Is there a formula that will give me a running total of the characters as
they are being typed in?
they are being typed in?
J
jlclyde
Is there a formula that will give me a running total of the characters as
they are being typed in?
- Show quoted text -
Not that I am aware of.
Jaycusto
T
tracktor
Is there a formula or VB code that will give a running count while typing in
the cell?
the cell?
D
dksaluki
"...keep a running total while typing?"
no, because when you're typing in a cell, you're in a different
"mode", that's why most of the toolbars get grayed out when you start
typing in a cell. Ctrl + Enter will make it so you don't move down a
cell when you hit enter. then you could always hit F2 again to edit
that cell. that's about the best I can think of. Is it super
important that you know WHILE you are typing?
dk
no, because when you're typing in a cell, you're in a different
"mode", that's why most of the toolbars get grayed out when you start
typing in a cell. Ctrl + Enter will make it so you don't move down a
cell when you hit enter. then you could always hit F2 again to edit
that cell. that's about the best I can think of. Is it super
important that you know WHILE you are typing?
dk
D
Dave Peterson
Nope.
If it's really important, you could create a userform that would allow you to
accept input from the user and count the characters as they're being typed.
If it's really important, you could create a userform that would allow you to
accept input from the user and count the characters as they're being typed.