That's what I'm using at the minute, but that only changes when you press
Enter.
Is there any way of changing B1 without pressing Enter?

"CLR" wrote:

In B1 put............

=128-LEN(A1)

Vaya con Dios,
Chuck, CABGx3



"RichardG" wrote:

I'm trying to set up a spreadsheet where the contents of cell A1 has a max
length of 128 characters. I want to give the number of characters left in
cell B1 which updates each time a character is entered in A1 without the user
having to press Enter.
Is this posible, and if so, does anyone know how?