Excel中一列数据1234123412341234……请问如何变成4列1111……2222...答:C2输入 =MID($A2,2,1)&MID($A2,6,1)&MID($A2,10,1)&MID($A2,14,1)D2输入 =MID($A2,3,1)&MID($A2,7,1)&MID($A2,11,1)&MID($A2,15,1)E2输入 =MID($A2,4,1)&MID($A2,8,1)&MID($A2,12,1)&MID($A2,16,1)下拉复制公式,然后复制全部公式结果,选择性粘贴为数值...