Maximum characters in cell

  • Thread starter Thread starter atvandle
  • Start date Start date
A

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
 
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
 
Thank you very much - made my Friday!

Peo Sjoblom said:
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
Click to expand...
 
Back
Top