Checking the length of cell contents
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?
|