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")