How to limit # of characters in a cell?

[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!

 

[Chip Pearson]

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

 

[Debra Dalgleish]

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.