Limit # of Characters in Cells

[zmurman]

Is there a way to limit the number of characters in a cell. ie: 29 characters
in one cell, 13 in another, etc.

 

[JE McGimpsey]

Is there a way to limit the number of characters in a cell. ie: 29 characters
in one cell, 13 in another, etc.

You can use Data/Validation/Allow:Text Length to limit the number of
characters. It won't limit the number entered, but it will display an
alert dialog and prevent a longer entry from being made.

You could use VBA to truncate an entry at a specified text length, but
again, you can't prevent the user from entering more characters to begin
with.