2024-05-05 05:26:24
先替换掉括号。。即可。。
Sub aa()
A1 = "(1,2,3,4)(5,6),(7,8,9)(10,11,12,13,14)"
A2 = "(11,12)(13,14,15)()(16,17)"
A3 = "()(55,34)"
A1 = Replace(Replace(A1, "(", ""), ")", "")
A2 = Replace(Replace(A2, "(", ""), ")", "")
A3 = Replace(Replace(A3, "(", ""), ")", "")
AA1 = Split(A1, ",")
AA2 = Split(A2, ",")
AA3 = Split(A3, ",")
End Sub