Right(string, length) returns a specified number of characters from the right end of a string : String Function « Data Type « VBA / Excel / Access / Word
Right(string, length) returns a specified number of characters from the right end of a string
Sub rightDemo()
Dim strPhone As String
strPhone = "123-1231233"
Dim strLocalNumber As String
strLocalNumber = Right(strPhone, 7)
Debug.Print strLocalNumber
End Sub