J**G
发帖数: 3310 | 1 文本中的数据是这样的
1 2 3 4 5
6 7 8 9 10
11 12 13 14 15
如果导入excel中，变成一个column
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
谢谢 | w****g
发帖数: 597 | 2 你可以写个EXCEL VBA代码小程序,先split string,再把数据导入.见vba例子
设 A1 = 11 12 13 14 15
Sub SplitRowToColumn()
Dim vString As Variant
Dim lCount As Long
Dim lCellCount As Long
lCellCount = 3
vString = Split(Cells(1, 1).Value, " ") // split cell A1
For lCount = LBound(vSecond) To UBound(vSecond)
lCellCount = lCellCount + 1
ActiveSheet.Cells(lCellCount, 1).Value = vString(lCount)
Next
End Sub
results are :
11 12 13 14 15
11
12
13
14
15 |
|
