Hello

I am trying to work out a way of finding out if two cells have any characters in common.

For example, in cell A1 I have the string ABCDEF in it. In A2 I have ACEFG. Both cells have the characters A, C, E and F present and would therefore return TRUE.

Is there anyway to do this in a concise formula?

Many thanks for your help in advance