View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Kevin B Kevin B is offline
external usenet poster
 
Posts: 1,316
Default Limiting cell size to 25 characters

Use data validation to limit minimum/maximum character lengths.

Click DATA in the menu, select VALIDATION. In the ALLOW combo box select
TEXT LENGTH, in the DATA combo box select BETWEEN, then set your lower and
upper limits
--
Kevin Backmann


"pj" wrote:

Does anyone know if there is a way to limit a cell/column to a certain number
of letters and/or numbers. I want the system to stop accepting data once I
hit 25 characters. This would save me having to count the data to make sure I
haven't exceeded 25.

Thanks