5,139
社区成员
发帖
与我相关
我的任务
分享
Sub test()
Range("B1:B20").Select
For Each objCell In Application.Selection
tempStr = ""
For i = 1 To Len(objCell.Value)
If IsNumeric(Mid(objCell.Value, i, 1)) = False Then
tempStr = tempStr & Mid(objCell.Value, i, 1)
End If
Next
objCell.Value = tempStr
Next
End Sub
Sub test()
Dim i As Integer
Dim tempStr As String
For i = 1 To Len(Range("J6").Value)
If IsNumeric(Mid(Range("J6").Value, i, 1)) = False Then
tempStr = tempStr & Mid(Range("J6").Value, i, 1)
End If
Next
Range("K6").Value = tempStr
End Sub