ExcelBanter - find text characters

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - find text characters (https://www.excelbanter.com/excel-discussion-misc-queries/25077-find-text-characters.html)

Micayla Bergen

find text characters

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

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

All times are GMT +1. The time now is 06:08 AM.