Count Characters in a cell

[tracktor]

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

Any help would be appreciated

 

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

 

[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

 

[Pete_UK]

The LEN function does this, as in:

=LEN(A1)

Hope this helps.

Pete

 

[tracktor]

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

 

[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

 

[tracktor]

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

 

[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

 

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