- Sub Macro1()
- Dim arr, brr, i&
- arr = [a2:a5]
- ReDim brr(1 To UBound(arr), 1 To 2)
- For i = 1 To UBound(arr)
- If InStr(arr(i, 1), "±") Then
- brr(i, 1) = 0 - Val(Mid(arr(i, 1), 2))
- brr(i, 2) = Val(Mid(arr(i, 1), 2))
- ElseIf InStr(arr(i, 1), ",") Then
- x = Split(arr(i, 1), ",")
- brr(i, 1) = Application.Min(Val(x(0)), Val(x(1)))
- brr(i, 2) = Application.Max(Val(x(0)), Val(x(1)))
- Else
- brr(i, 1) = 0: brr(i, 2) = Val(arr(i, 1))
- End If
- Next
- Range("b2").Resize(UBound(brr), 2) = brr
- End Sub
复制代码 |