How to know that character type in one cell of xls is more that s.
 

Q : How to know that character type in one cell of xls is more that s...
E.g How i will come to know that i typed more than specified charater, when
i am typing in that particular cell

Your character to test is in A1
In another cell enter =CODE(A1)CODE("s"). You will get TRUE or FALSE
Or use =IF(CODE(A1)CODE("s"),"Bigger","Not bigger")
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Dharamendra" <Dharamendra @discussions.microsoft.com wrote in message
...
Q : How to know that character type in one cell of xls is more that s...
E.g How i will come to know that i typed more than specified charater,
when
i am typing in that particular cell

Excel has no way of knowing that you typed too much while you are typing.

Only after you leave the cell will you be able to know.

You can use Data Validation to bring up a message that you typed too many
characters(text length).

You could use event code to raise a message after you have left the cell.


Gord Dibben Excel MVP



On Thu, 10 Mar 2005 14:11:02 -0800, "Dharamendra" <Dharamendra
@discussions.microsoft.com wrote:

Q : How to know that character type in one cell of xls is more that s...
E.g How i will come to know that i typed more than specified charater, when
i am typing in that particular cell