Another configuration:

=IF(OR(LEN(A1)={7,11}),"Yes","No")
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===


"Paula" wrote in message
...
Hi, Can you help me with a formula, I need to identify all instances where a
cell contains an entry with either 7 or 11 characters. so for example the
following would be recognised as yes, anything not 7 or 11 characters would
be no. Hope you can help.

LON-NYC
LON-NYC-LON

Many thanks
Paula