得分
13
Advertisement
将文本复制/粘贴到文本编辑器中 将所有空格字符替换为carriagereturn/linefeeds 保存为TXT文件。在Excel中打开该文件。
写一个小VBA来处理你的列表
这假设值的列表在一个单元格中,并且被选中。将结果放在下面的单元格中
Sub zx()
Dim a() As String
Dim v As Variant
Dim i As Long
Dim j As Long
a = Split(ActiveCell.Value, " ")
ReDim v(1 To UBound(a) + 1, 1 To 2)
For i = 1 To UBound(a) + 1
j = InStr(a(i - 1), ",")
v(i, 1) = Val(Left(a(i - 1), j - 1))
v(i, 2) = Val(Mid(a(i - 1), j + 1))
Next
ActiveCell.Offset(1, 0).Resize(UBound(a) + 1, 2) = v
End Sub