Limit number of characters in a cell

[Dr Senji]

Hi,

Is there a way to limit the number of characters that a user can key into a
cell.

I want to get a list of names and addresses imputted by user, but I don't
want them to be more than 35 characters.

Thanks for the help

Dr. Senji

 

[Dave Peterson]

Take a look at Data|Validation.

You can have excel yell at the user when they hit enter after typing in a
too-long string.

 

[Dr Senji]

Thanks. I guess I was trying to make it too hard.

Dr. Senji