|
发表于 2012-10-30 21:47
|
显示全部楼层
本楼为最佳答案
- Sub ExtractNo()
- Dim ArrC, Result, i
- Result = Cells(6, 3).Value
- For i = 2 To 4 Step 2
- For Each ArrC In Split(Cells(i, 3).Value, " ")
- Result = Replace(Replace(Result, ArrC, ""), " ", " ")
- Next
- Next i
- Cells(9, 3) = Result
- End Sub
复制代码 |
|