I need a formula that keeps a running count of characters in a cell.

Any help would be appreciated

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.

tracktor wrote:

I need a formula that keeps a running count of characters in a cell.

Any help would be appreciated

--

Dave Peterson

On May 20, 7:40*pm, tracktor
wrote:
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

The LEN function does this, as in:

=LEN(A1)

Hope this helps.

Pete

On May 21, 1:40*am, tracktor
wrote:
I need a formula that keeps a running count of characters in a cell.

Any help would be appreciated

Is there a formula that will give me a running total of the characters as
they are being typed in?

"Dave Peterson" wrote:

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.

tracktor wrote:

I need a formula that keeps a running count of characters in a cell.

Any help would be appreciated

--

Dave Peterson

On May 20, 7:55*pm, tracktor
wrote:
Is there a formula that will give me a running total of the characters as
they are being typed in?



"Dave Peterson" wrote:
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.

tracktor wrote:

I need a formula that keeps a running count of characters in a cell.

Any help would be appreciated

--

Dave Peterson- Hide quoted text -

- Show quoted text -

Not that I am aware of.
Jaycusto

Is there a formula or VB code that will give a running count while typing in
the cell?


"jlclyde" wrote:

On May 20, 7:40 pm, tracktor
wrote:
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

"...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

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.

tracktor wrote:

Is there a formula that will give me a running total of the characters as
they are being typed in?

"Dave Peterson" wrote:

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.

tracktor wrote:

I need a formula that keeps a running count of characters in a cell.

Any help would be appreciated

--

Dave Peterson


--

Dave Peterson