If I type in A1 123456 and then in A2 type the formula =IF(Len(A1)>6,"A","B") I would expect to receive the answer A - but for some strange reason it returns B (i.e.more than 6 characters!!)
I have ensured I have no trailing spaces using both =Clean() and =Trim()
Please, am I doing something wrong or am I using the functions incorrectly?
Thanks Roberta
I have ensured I have no trailing spaces using both =Clean() and =Trim()
Please, am I doing something wrong or am I using the functions incorrectly?
Thanks Roberta