Option Explicit
Sub test()
Dim ar, br, i&, t, m, p
ar = [a1].CurrentRegion.Resize(, 6)
For i = 2 To UBound(ar)
br = Split(ar(i, 1), "-")
t = Split(br(0), "g")
m = Split(br(1), "/")
p = Split(t(1), "×")
ar(i, 2) = m(0)
ar(i, 3) = m(1)
ar(i, 4) = t(0)
ar(i, 5) = p(0)
ar(i, 6) = p(1)
Next
[a1].CurrentRegion.Resize(, 6) = ar
End Sub
Sub kk()
Dim regx As Object
Dim brr(), arr()
Set regx = CreateObject("vbscript.RegExp")
With regx
.Global = True
.Pattern = "(\d+)"
End With
irow = Sheet1.Cells(Rows.Count, 1).End(3).Row
arr = Sheet1.Range("a2:a" & irow)
ReDim brr(1 To UBound(arr), 1 To 5)
For i = 1 To UBound(arr)
ar = Split(arr(i, 1), "-")
Set mat = regx.Execute(ar(0))
ar_split = Split(ar(1), "/")
n = n + 1
brr(n, 1) = ar_split(0)
brr(n, 2) = ar_split(1)
brr(n, 3) = mat(0).SubMatches(0)
brr(n, 4) = mat(1).SubMatches(0)
brr(n, 5) = mat(2).SubMatches(0)
Next i
With Sheet1
.Range("b2").Resize(n, 5) = brr
End With
End Sub