RIGHT function in VBA returns the Specified number of characters from the end of a text string
Syntax: Right(String,Length)
Sub RIGHT_1()
Dim mystring As String
mystring = "Narendra Modi"
MsgBox Right(mystring, 4)
'Output: "Modi"
'To get first name dynamically use RIGHT & InStr functions
MsgBox Right(mystring, Len(mystring) - InStr(1, mystring, " "))
'Output: "Modi"
End Sub