如图,请问如何让左边单元格里的内容变成右边对应表格里的内容?答:如下图,D2单元格输入公式=TRIM(MID(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(TEXTJOIN("@",1,IF(ISNUMBER(FIND({"饰","备注"},$A$1:$A$15)),SUBSTITUTE($A$1:$A$15," ",),"")),"@备注"," "),"@"," "),"饰"," ")," ",REPT(" ",1000)),(INDEX({2,1,3},MATCH...