find text characters

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

Guest

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

Try something like this:

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

Biff
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
check first 3 characters of a cell and compare to a table 4
Search formula showing results plus 100 characters 2
CSV->Excel Data Problem 1
delimit using a formula 2
How do I get more than 255 characters into a cell? 3
Excel Functions 6
Truncate / Substitute Formulas 3

Back
Top