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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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")
 
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
 
Back
Top