View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 1,726
Default count signs in a cell

Use data validation, allow type of custom, and a formula of

=LEN(A1)<=34

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Kjell" wrote in message
...
I want to write in maximum 34 sign in a cell. If I writes 1 signs moore I
want to get a warning. Is this possible in Excel Worksheet?
--
Kjell