按规则取最左边的字符 (9528)

C2=IF(1-ISERR(FIND(LEFT(B2),"wyaoe")),,LEFT(B2,2-ISERR(FIND(LEFT(B2),"zhchsh"))))

另解=IF(OR(LEFT(B2)={"w","y","a","o","e"}),,LEFT(B2,1+OR(LEFT(B2,2)={"zh","ch","sh"})))