I am looking for the formula to find part of the string for example: "Yes" in "No,Yes,N/A,No,Yes,N/A,No" string and if "Yes" exists in the string, then cut out everything else in the same string and live just "Yes" in it
If "No,Yes,N/A,No,Yes,N/A,No" has "Yes" in the string then cut all from "No,Yes,N/A,No,Yes,N/A,No" and live just one "Yes"