第1个回答 2007-05-14
Dim tmpStr As String
tmpStr = Text1
tmpStr = Replace(tmpStr, "-", "")
tmpStr = Replace(tmpStr, "/", "")
变量"tmpStr"就是你想要的效果!
函数"Replace"的作用,是把一些你不想要的字符进行替换.
第2个回答 2007-05-14
Public Function extract_num(mystr As String) As String
extract_num = ""
For i = 1 To Len(mystr)
If IsNumeric(Mid(mystr, i, 1)) Then
extract_num = extract_num + Mid(mystr, i, 1)
End If
Next i
End Function