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]