Creating a character limit

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
Data > Valadation > Allow > Text Length > set parameters.

HTH
Regards,
Howard
 
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.
 
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 must log in or register to reply here.

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
2007 cell character limit 11
Need to count no. of rows where cell in column A = "value1" AND cellin column B (same row) = "value2 2
Restrict Data Entry 1
Eliminating cells with non-matching characters 1
Need to count cells in Column1 where each cell's row also hasspecified value in Column2 1
Cell input control 3
Put parts of cell into separate columns 3

Back
Top