View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default Can I restrict a text column to a specific number of characters?

Hi,

Select the column then

data|Validation

From the drop down select 'Text Length' and set you Min and max values

Mike

"Irene Threadgold" wrote:

Is there a way in which I can restrict the number of characters entered in an
excel spreadsheet column, eg, maximum 50 characters.