Creating a character limit

G

Guest

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.
 
L

L. Howard Kittle

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

HTH
Regards,
Howard
 
G

Guest

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.
 
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
 

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

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Restrict Data Entry 1
2007 cell character limit 11
Text wrap spec 4
cell character limit 8
Maximum result in calculated field 2
Put parts of cell into separate columns 3
Extract different strings from a cell? 5

Top