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...
That's all, I hope it helped! If not, feel free to email me at erik [at] vbahowto [dot] com
|
Are you struggling to learn VBA?
If your answer to the above question is yes, then I strongly recommend that you check out these VBA Crash Course videos |
