Limiting Cell Characters

  • Thread starter Thread starter George
  • Start date Start date
G

George

Hello

I don't know if you can help, I have searched Excel and
Excel Help for some type of Cell formatting which will
limit the number of Characters which a user is able to
enter into a cell.

I have already set the cell width and wrapped the text but
this still allows for entry of too many characters?

Any help you can offer is greatly appreciated.

Thanks

George
 
You can use Data>Validation
Choose to Allow: Text Length
Set the minimum and maximum number of characters

To help the users, add an input message, that describes the limits

You can also add an Error Alert, but that won't appear until they've
typed the data and pressed Enter.
 
Back
Top