Hi All,
Does anyone has a function that validates the fax number.Plz help me on this.Thankz in advance.
Printable View
Hi All,
Does anyone has a function that validates the fax number.Plz help me on this.Thankz in advance.
what can't be in a fax number?
please clarify.
i want to remove all characters other than the numbers
VB Code:
Function ExtractNumbers(s As String) As String Dim ba() As Byte,v As byte,i& ba = s For i = 0 To UBound(ba) step 2 v = ba(i) If v > 47 And v < 58 Then ExtractNumbers = ExtractNumbers & Chr$(v) Next i End Function