View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Paula Paula is offline
external usenet poster
 
Posts: 138
Default IF OR LEN Formula Question

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