 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / May 2008Maximum characters in cell
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  SignatureRegards, Peo Sjoblom > 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? [quoted text clipped - 4 lines] > Any help please > Ann Thank you very much - made my Friday! > Look at data>validation and select text length. It won't prevent someone > pasting text but [quoted text clipped - 12 lines] > > Any help please > > Ann |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.