You will receive an error message if you exceed the limit.

Assuming you have used Data Validation.

If you want the limit at 30 with no error message you would need VBA event
code.


Gord Dibben MS Excel MVP

On Wed, 17 Dec 2008 14:04:19 -0800, filpass
wrote:

Dear Excel forum members,

I would like to limit the number of characters in a cell. How shall I do?

If a name is 50 characters long and I set up the limit at 30, will the 30
characters appear or will I receive an error message?

Thanks a lot for your help!