Excel表格横向分列公式
具体分列的字符可修改200,200-199
=TRIM(MID(SUBSTITUTE($A1," ",REPT(" ",200)),COLUMN(A1)*200-199,200))
Excel表格横向分列公式
具体分列的字符可修改200,200-199
=TRIM(MID(SUBSTITUTE($A1," ",REPT(" ",200)),COLUMN(A1)*200-199,200))
扫码打开当前页
之前