excel 一个单元格内的数据如何调换顺序?答:前提:单元格内各组数据间有逗号,而且仅作分隔用,操作:1、选择数据所在列(例如A列)2、”数据“菜单——分列——分隔符号——逗号——完成(出现ABCDE五列)3、剪切D列,右击列标C——插入已剪切单元格 4、在F1格输入 =CONCATENATE(A1,",",B1,",",C1,",",D1,",",E1)如有需要,可...
把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...