Function GetNewNumber(Byval strNum As String) As String
Dim iLen,i As Integer
Dim strTmp As String
iLen=Len(strNum)
For i=1 to iLen strTmp =Mid(strNum,i,1) IF isNumeric(strTmp) Then GetNewNumber=GetNewNumber & strTmp End IF
Next If Left(GetNewNumber,1)="0" Then GetNewNumber="7" & Mid(GetNewNumber,2)
End Function