vba怎麼分割多個字元-CSDN論壇-CSDN.NET-中國最大的IT技術社區
可以按逗號分割,然後在按空格分格:如:Sub fenge() Dim a As String Dim arry1() As String Dim arry2() As String Dim i As Integer Dim k As Integer Dim b As String a = "2,3 5 4 14,4" b = "" arry1 = Split(a, ",") For i = 0 To UBound(arry1) arry2 = Split(arry1(i), " ")...