' convert a telephone string into a phone numberFunction PhoneNumberFromString(ByVal PhoneString As String) As String Dim i As Integer Dim acode As Integer Const PhoneDigits = "22233344455566677778889999" ' prepare result in uppercase PhoneNumberFromString = UCase$(PhoneString) For i = 1 To Len(PhoneNumberFromString) acode = Asc(Mid$(PhoneNumberFromString, i, 1)) Select Case acode Case 48 To 57 ' nothing to do Case 65 To 90 ' replace with corresponding char in PhoneChars Mid$(PhoneNumberFromString, i, 1) = Mid$(PhoneDigits, _ acode - 64, 1) Case Else ' raise an error if anything else Err.Raise 5, , "Invalid character" End Select Next End Function



Top 5 B2B SaaS Marketing Agencies for 2023
In recent years, the software-as-a-service (SaaS) sector has experienced exponential growth as more and more companies choose cloud-based solutions. Any SaaS company hoping to stay ahead of the curve in this quickly changing industry needs to invest in effective marketing. So selecting the best marketing agency can mean the difference