Limit number of characters in a cell

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dr Senji - 17 May 2005 00:46 GMT

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

Reply to this Message

Dave Peterson - 17 May 2005 00:51 GMT

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.

> Hi,
>
[quoted text clipped - 7 lines]
>
> Dr. Senji

Signature

Dave Peterson

Reply to this Message

Dr Senji - 17 May 2005 01:06 GMT

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

Dr. Senji

> Take a look at Data|Validation.
>
[quoted text clipped - 13 lines]
>>
>> Dr. Senji

Reply to this Message