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

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

Public Sub GetFirstName() 

      Dim strFirstName As String 

      strFirstName = Range("A2") 

      strFirstName = Left(strFirstName, 3) 

      Range("B2") = strFirstName 

End Sub 

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

Now watch how it’s done…

Let me know if you have any questions

[simple_contact_form]