Hi, Hope you can help me, I am half way to a formula but can't quite get the
last stage.

I have a sequence, example BHX-CDG/TLS-CDG/BHX

I am using the following formula
==IF(AND(LEFT(H53076,3)=RIGHT(H53076,3),LEN(H53076 )=19),"YES","NO")

But I need to take it a stage further to also say if the CDG and CDG = the
same, so if position 5-7 matches positions 13- 15 as an additional condition,
so in the example above if CDG and CDG were the same that would be the extra
condition, but I can't work out how to get there.

Any ideas?

Many thanks

Paula