excel 一个单元格内的数据如何调换顺序?答:2、”数据“菜单——分列——分隔符号——逗号——完成(出现ABCDE五列)3、剪切D列,右击列标C——插入已剪切单元格 4、在F1格输入 =CONCATENATE(A1,",",B1,",",C1,",",D1,",",E1)如有需要,可填充公式 5、复制F列,选择性粘贴——数值,至任意列即可获得第三、四组数据对调的结果 ...
excel 一个单元格内的数据如何调换顺序?答:右击列标C——插入已剪切单元格\x0d\x0a4、在F1格输入\x0d\x0a =CONCATENATE(A1,",",B1,",",C1,",",D1,",",E1)\x0d\x0a 如有需要,可填充公式\x0d\x0a\x0d\x0a5、复制F列,选择性粘贴——数值,至任意列即可获得第三、四组数据对调的结果 ...