I am feeling like a fool. Not function. If I use A1 to write in a name, using
letters and numbers f.ex. "1. floor detector" I want to get a message on the
screen, in some way, if I, while I am writing, exceed a total of letters and
numbers of 34.
--
Kjell


zz skrev:

well, in a cell write

=if(len(write_cell_ref_here)34,"Too long","")

--
---
zz [MX]
cuasi-musico,semi-poeta y loco


"Kjell" wrote in message
...
Sorry. Don`t functions. May be I do something wrong?
--
Kjell


"Bob Phillips" wrote:

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