Limit number of characters in a cell

D

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
 
D

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cell input control 3
Autocopy the first cell with more than 30 characters to a different sheet? 1
2007 cell character limit 11
Restrict Data Entry 1
counting or limiting characters 2
How to limit number of characters in the cell 2
Restricting more than x number of characters in a cell.... 1
code to dis[play a message if the active cell contains an asteric 2

Top