This is a text and video example of how to write a VBA Right function:

********************************************************************

Public Sub GetLastName() 

      Dim strLastName As String 

      strLastName = Range("A2") 

      strLastName = Right(strLastName, 8) 

      strLastName = Trim(strLastName) 

      Range("C2") = strLastName 

End Sub	

*********************************************************************

Now watch how it’s done…

Let me know if you have any questions

[simple_contact_form]