D
Darin
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.
cell? E.g. limiting a cell to a maximum of 25 characters.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
L
L. Howard Kittle
Data > Valadation > Allow > Text Length > set parameters.
HTH
Regards,
Howard
HTH
Regards,
Howard
T
Trevor Shuttleworth
Use Data | Validation
D
Darin
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.
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.
G
Gord Dibben
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
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