Maximum characters in cell

[atvandle]

Does anyone know of a way to prevent users from continuing to enter
information in a cell once the max number of characters has been reached?
One option would be to count characters. I know there is a way to count
words, Is there a way to count "characters". Since the max is 250 per cell,
a counterin the adjacent cell would work.
Any help please
Ann

 

[Peo Sjoblom]

Look at data>validation and select text length. It won't prevent someone
pasting text but
it will prevent someone from keying in text

Btw, the number of characters are officially around 32000 but only 1024 are
visible
although that can be changed using alt + enter on a regular basis

--


Regards,


Peo Sjoblom

 

[atvandle]

Thank you very much - made my Friday!

Look at data>validation and select text length. It won't prevent someone
pasting text but
it will prevent someone from keying in text

Btw, the number of characters are officially around 32000 but only 1024 are
visible
although that can be changed using alt + enter on a regular basis

--


Regards,


Peo Sjoblom