character limit

[singkit]

Please help!

I need to know if there is a way I can limit entry on
excel.

Example
On field I want only 10 character to be input and if that
exceed it will not allow the user to input more than 10
character

Thanks you!

 

[Dave R.]

Try data>validation>

allow; text length
data; less than or equal to
maximum; 10

 

[singkit]

can you give me specific formula. thanks

-----Original Message-----
Try data>validation>

allow; text length
data; less than or equal to
maximum; 10





.

 

[Dave R.]

Hmm. A formula wont limit entry as well as data validation would. What you
can do is alert your user that they have entered too much. For example, in
an adjacent cell, use

=IF(LEN(A1)>10,"HEY!!!",""))

then color it red and bold it.