H2公式：
=LEFT(B2,FIND("（",B2))&IF(ISNUMBER(FIND("a",G2)),C2,"")&IF(ISNUMBER(FIND("b",G2)),D2,"")&IF(ISNUMBER(FIND("c",G2)),E2,"")&IF(ISNUMBER(FIND("d",G2)),F2,"")&" )。"
下拉。
=$B2&PHONETIC(OFFSET($B2,0,MATCH(LEFT($G2,1),{"a","b","c","d"}),1,LEN(G2)))
用上诉函数试下
=IFERROR($B2&PHONETIC(OFFSET($B2,0,MATCH(LEFT($G2,1),{"a","b","c","d"}),1,LEN(G2))),"没有答案")
纠错的上诉函数。
选中两个单元格点合并
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024