- Sub demo()
- Dim arr
- arr = Range("a2").CurrentRegion.Value
- Dim i&, j&
- For i = 2 To UBound(arr)
- If Len(arr(i, 1)) Then
- For j = 1 To Len(arr(i, 1))
- If InStr(1, arr(i, 1), Left(arr(i, 2), j)) = 0 Then
- Exit For
- End If
- Next
- If j Then
- arr(i, 3) = Left(arr(i, 1), j - 1)
- arr(i, 4) = Mid(arr(i, 1), j)
- arr(i, 5) = Mid(arr(i, 2), j)
- End If
- End If
- Next
- Range("a2").Resize(UBound(arr), UBound(arr, 2)).Value = arr
- End Sub
复制代码 |