Hi!

Try something like this:

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

Biff

"Micayla Bergen" wrote in message
...
am trying to have a formula to return a value if the number of text
characters in another cell is more than 3
thanks