Thread: how do I set a maximum characters in a specific cell
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default how do I set a maximum characters in a specific cell
Hi,

Select the cell then

data|Validation
From the dropdown select 'Text Length' and set you min/max values

Mike

"ochie" wrote:

Is there a non-VBA way to set a maximum number of characters in a specific
cell?

Reply With QuoteReply With Quote