2 data validations on same cell?

[lezawang]

Hi
Can I have 2 data validation rules applied on the same cell? For example I want user only enter text in cell A1 and the text should be at least 2 characters. So I thought I should go to Data Validation-->Custom--> Formula and use this formula

=isText(A1)

but how can I control the length now? Thank you so much.

 

[Gerald Higgins]

Try this . . .

=AND(ISTEXT(A1),LEN(A1)>1)

 

[jproffer]

try this:

=AND(ISTEXT(A1),LEN(A1)>1)

Ahhhhh, I'm too slow . Well at least we know it's a consensus....that should do it.