excel表格怎么***一行数字

1.在Word或excel中怎么将一行数字或字符串分列

例如在excel中对数据进行分列，

下一步确定即可。有不同的分列类型的，可以按照自己的需要选择。

2.Excel怎么把一个单元格里的数字类似分列一样分成行,有公式吗

数字间空格的，参照此公式，放结果的起始单元格=IF(ROW(A1)>LEN(TRIM(A$1))-LEN(SUBSTITUTE(TRIM(A$1)," ",""))+1,"",LEFT(MID(" "&TRIM(A$1),FIND("+",SUBSTITUTE(" "&TRIM(A$1)," ","+",ROW(A1)))+1,100)&" ",FIND(" ",MID(" "&TRIM(A$1),FIND("+",SUBSTITUTE(" "&TRIM(A$1)," ","+",ROW(A1)))+1,100)&" ")-1））下拉