把Excel单元格中的内容调换顺序,把最后的值调换到最前答:在B2单元格输入以下公式,然后向下填充公式 =IF(LEN(A2)-LEN(SUBSTITUTE(A2,",",""))=2,MID(A2,FIND("座",SUBSTITUTE(A2,",","座",2))+1,99)&","&LEFT(A2,FIND("座",SUBSTITUTE(A2,",","座",2))-1),IF(LEN(A2)-LEN(SUBSTITUTE(A2,",",""))=1,RIGHT(A2,LEN(A2)-FIND...