count signs in a cell
 

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

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

count signs in a cell
 

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

count signs in a cell
 

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

count signs in a cell
 

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

count signs in a cell
 

You can't get the error whilst you type, only after you hit enter.

--

HTH

Bob Phillips

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

"Kjell" wrote in message
...
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

count signs in a cell
 

when you type in a cell, excel goes into "edit mode" , that means, no macro
can called, no events are trigered and no code is executed until excel
leaves "edit mode".

excel is pretty much like Men's brain, it only can use half the brain at a
time :-)




but you can do this, if you don't mind waiting until you finish typing


In data menu

* goto validation

in the first field .

* select "Text lenght" option

in the second one
* select "less than"

in the third one

* type you lenght limitation , eg "34"

* 'click' "Ok"


then in the error alert tab

* check "show error alert after invalid data entered"

in the first combo

* choose the type of alert [ stop,warning,info,etc.]

in the first field

* type the title of you error message eg. "Damn!, you cannot type that
much!!" ;-)

in the second field

* type the error description you want the user to read eg. "What do you
think i am?, notepad?" LOL,



sorry.... ejm, ejm




Now,

*type something into your validated cell,



and finally

* have some fun



--
hope this works, if doesn't, tell us please.
---
zz [MX]
cuasi-musico,semi-poeta y loco




"Bob Phillips" wrote in message
...
You can't get the error whilst you type, only after you hit enter.

--

HTH

Bob Phillips

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

"Kjell" wrote in message
...
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

count signs in a cell
 

OK. I understand. My half brain (the working part) can wait until typing is
finished.
Thank you zz and Bob, for spending time on me and my problem. Have a nice
day whatever yuo may be in the world.
--
Kjell


zz skrev:

when you type in a cell, excel goes into "edit mode" , that means, no macro
can called, no events are trigered and no code is executed until excel
leaves "edit mode".

excel is pretty much like Men's brain, it only can use half the brain at a
time :-)




but you can do this, if you don't mind waiting until you finish typing


In data menu

* goto validation

in the first field .

* select "Text lenght" option

in the second one
* select "less than"

in the third one

* type you lenght limitation , eg "34"

* 'click' "Ok"


then in the error alert tab

* check "show error alert after invalid data entered"

in the first combo

* choose the type of alert [ stop,warning,info,etc.]

in the first field

* type the title of you error message eg. "Damn!, you cannot type that
much!!" ;-)

in the second field

* type the error description you want the user to read eg. "What do you
think i am?, notepad?" LOL,



sorry.... ejm, ejm




Now,

*type something into your validated cell,



and finally

* have some fun



--
hope this works, if doesn't, tell us please.
---
zz [MX]
cuasi-musico,semi-poeta y loco




"Bob Phillips" wrote in message
...
You can't get the error whilst you type, only after you hit enter.

--

HTH

Bob Phillips

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

"Kjell" wrote in message
...
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