How to limit # of characters in a cell?

  • Thread starter Thread starter Sean
  • Start date Start date
S

Sean

I have a label that will only accept so many characters -
I want to limit the number of characters someone can
enter into a cell. How do I do that?
Thanks in advance!
 
Sean,

You can use Data Validation to do this. Select the cell, then go
to the Data menu and choose Validation. In that dialog, choose
"Text Length" in the "Allow" list, and put in the appropriate
values.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
And to help the user, add an Input Message and and Error Message in the
data validation dialog box, to tell them how many characters will be
allowed.
 
Back
Top