find text characters

Micayla Bergen · May 6, 2005

am trying to have a formula to return a value if the number of text
characters in another cell is more than 3
thanks

Biff · May 6, 2005

Hi!

Try something like this:

=IF(AND(ISTEXT(A1),LEN(A1)>3),"Yes","No")

Biff