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

Look at datavalidation 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" wrote in message
...
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

Thank you very much - made my Friday!

"Peo Sjoblom" wrote:

Look at datavalidation 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" wrote in message
...
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