Excel With VBA

VBA Trim

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

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

Public Sub GetLastName() 

      Dim strLastName As String 

      strLastName = Range("A2") 

      strLastName = Right(strLastName, 8) 

'THE TRIM FUNCTION CLEANS THE VBA STRING VARIABLE OF 
'ANY LINGERING SPACES BOTH BEFORE AND AFTER...
'IT MAKES " Jack" (WITH A SPACE IN THE BEGINNING)
' LOOK LIKE "Jack" (NO SPACES). 

      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]

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

admin