=IF(OR(LEN(F2)=7,AND(LEFT(F2,3)=RIGHT(F2,3),LEN(F2 )=11)),"yes","no")
--
David Biddulph

Paula wrote:
Hi

In a previous posting I was advised on the below formula, however I
need to expand it further to ask for the following conditions

If the length is 11 characters and the left 3 characters and right 3
charaters are the same say yes
If the length is 7 characters say yes.

I'm stuck on how to do this, can you help me adapt the below formula
or advise of what I could use?

Kind regards

Paula


=IF(AND(LEFT(F2,3)=RIGHT(F2,3),LEN(F2)=11),"yes"," no")