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

Without knowing the layout of your worksheet it's difficult to give a
definitive formula but try working with this:
=IF(OR(LEN(A1)=7,LEN(A1)=11),"yes","no")

"Paula" wrote:

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

let say LON-NYC on cell A1, you may set formula in A2
=IF(LEN(A1),"Yes","No")

"Paula" wrote:

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

Paula,

If youe happy with TRUE/False use this

=OR(LEN(A1)=7,LEN(A1)=11)

If it needs to be YES/NO, use this

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

Drag down as required.

Mike

"Paula" wrote:

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

=IF(OR(LEN(A1)=7,LEN(A1)=11),"yes","no")


On 6 Maj, 11:51, Paula wrote:
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

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