Thank very much for your help. Thanks to xiaomayi too .. you guys have been a darling and great help ...Originally posted by the_unknown:for length, use =LEN(A1) where A1 contains your text. To do this for a column, just copy the formula.
for your qn, use =IF(LEN(A1)<11;"less";IF(LEN(A1)=11; "exactly";"more" ))