Paula,

Try this. Drag down as required.

=IF(SEARCH("LHR-SEA-LHR",A1),"It's Here", "Not Here")

Mike

"Paula" wrote:

Hi,

I have a column where the cell contains vaiable information, and I want to
find any cell which contains LHR and SEA and LHR again, the format of the
text will be variable in length and separators and will not always contain
these 3 codes, a couple of examples of what the string will look like are
below:

AMS/DXB-AMS/LHR-SEA-LHR/AMS
DUB-/AMS/LHR-SEA-LHR-AMS-DUB

any ideas of formulas that will find a cell which contains sea and lhr
within it?

Rgds Paula