Find first occurrence from set of strings

[123love55448]

Hi All,

For example, if I have three words that I am looking for (A, B, C) and there is a column containing list of strings (D, S, E, A, C, B, D, E). I want to whether list of strings contain (A, B, C) or not in the first 3 lists. Then if there is (A, B, C) I want to know which one appear first.

Input Column                 Expected Output1            Expected Output 2       

(A, B, C, D, E, F, G)       Yes                                    A

(B, E, G, A, D, C)           Yes                                    B

(U, O, P, P)                    No                                      - 

(E, C, Q, W)                   Yes                                    C

(C, D, A, W, A, O)           Yes                                   C

A bit confusing, but very appreciated if anyone can help.

[Luke_C]

Hi @123love55448 

You can use the find and replace tool:

[binuacs]

@123love55448 Another way of doing this

[Emmanuel_G]

Hi @123love55448 ,

Another explicit and clear way to do this