test1114

=RIGHT(A1,LEN(A1)-FIND(“@”,SUBSTITUTE(A1,”/”,”@”,LEN(A1)-LEN(SUBSTITUTE(A1,”/”,””)))))

=MID(A1,FIND(““,SUBSTITUTE(A1,”/”,”“,LEN(A1)-LEN(SUBSTITUTE(A1,”/”,””))))+1,LEN(A1))

=RIGHT(A1,LEN(A1)-FIND(“●”,SUBSTITUTE(A1,”/”,”●”,LEN(A1)-LEN(SUBSTITUTE(A1,”/”,””)))))

Text.BetweenDelimiters([Column6], “email=”, “:”)

=IF(AND(N3=”〇”,OR(P3=”SS”,P3=”S”,P3=”A”)),”〇”,””)

=IF(AND(A2=”〇”,NOT(OR(B2=”SS”,B2=”S”,B2=”A”))),”〇”,””)