[已解决]單元格數據拆分

wade_tan · 发表于 2016-11-5 21:15

使用公式將A1單元格拆分為C7：D7的格式，可延伸的

最佳答案

心正意诚身修

2016-11-5 21:53

=TRIM(MID(SUBSTITUTE(SUBSTITUTE($A$1," ",REPT(" ",99)),"：",REPT(" ",99)),(ROW(A1)*2+COLUMN(A1)-2)*99-98,99))

心正意诚身修 · 发表于 2016-11-5 21:53

=TRIM(MID(SUBSTITUTE(SUBSTITUTE($A$1," ",REPT(" ",99)),"：",REPT(" ",99)),(ROW(A1)*2+COLUMN(A1)-2)*99-98,99))

苏子龙 · 发表于 2016-11-6 13:19

少几个字符=TRIM(MID(SUBSTITUTE(SUBSTITUTE($A$1," ","："),"：",REPT(" ",99)),(ROW(A1)*2+COLUMN(A1)-2)*99-98,99))

		自动登录	找回密码
密码			注册