I would appreciate any help with the following.
A1 contains the name of a city say Reading.
F1 contains a mnemonic for that city which in this case is logically RE. However the RE is not always the only letters in the cell.
So what I need is a CF formula that will check if the first 2 characters in A1 are anywhere in F1.
As ever any help is most appreciated.
A1 contains the name of a city say Reading.
F1 contains a mnemonic for that city which in this case is logically RE. However the RE is not always the only letters in the cell.
So what I need is a CF formula that will check if the first 2 characters in A1 are anywhere in F1.
As ever any help is most appreciated.