Creating a character limit

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Darin - 12 Jul 2006 18:17 GMT

Is it possible to create a limit on how many characters can be entered into a
cell? E.g. limiting a cell to a maximum of 25 characters.

Reply to this Message

L. Howard Kittle - 12 Jul 2006 18:35 GMT

Data > Valadation > Allow > Text Length > set parameters.

HTH
Regards,
Howard

> Is it possible to create a limit on how many characters can be entered
> into a
> cell? E.g. limiting a cell to a maximum of 25 characters.

Reply to this Message

Darin - 12 Jul 2006 18:49 GMT

Thank you for the info. One follow-up question. Is it possible to cease the
input of characters once the limit has been reached? So as to eliminate the
need to edit the cell due to the error message generated by the limit
parameter.

Thanks in advance.

> Data > Valadation > Allow > Text Length > set parameters.
>
[quoted text clipped - 5 lines]
> > into a
> > cell? E.g. limiting a cell to a maximum of 25 characters.

Reply to this Message

Gord Dibben - 12 Jul 2006 19:48 GMT

Darin

You cannot use DV to actually "cease" the entry of characters when you reach the
25 limit.

You are stuck with the message and editing.

Excel has no way of knowing what you have typed in a cell until you leave the
cell.

Gord Dibben MS Excel MVP

>Thank you for the info. One follow-up question. Is it possible to cease the
>input of characters once the limit has been reached? So as to eliminate the
[quoted text clipped - 12 lines]
>> > into a
>> > cell? E.g. limiting a cell to a maximum of 25 characters.

Reply to this Message

Trevor Shuttleworth - 12 Jul 2006 18:42 GMT

Use Data | Validation

> Is it possible to create a limit on how many characters can be entered
> into a
> cell? E.g. limiting a cell to a maximum of 25 characters.

Reply to this Message