MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Trim text - probably very simple


Posted by Daniel on September 18, 2000 8:25 AM

I need to trim text with VBA. Any suggestions?


Posted by Ivan Moala on September 18, 0100 9:38 AM

Daniel,
From help files:
This example uses the LTrim function to strip leading spaces and the RTrim function to strip trailing spaces from a string variable. It uses the Trim function to strip both types of spaces.

Dim MyString, TrimString
MyString = " <-Trim-> " ' Initialize string.
TrimString = LTrim(MyString) ' TrimString = "<-Trim-> ".
TrimString = RTrim(MyString) ' TrimString = " <-Trim->".
TrimString = LTrim(RTrim(MyString)) ' TrimString = "<-Trim->".
' Using the Trim function alone achieves the same result.
TrimString = Trim(MyString) ' TrimString = "<-Trim->".

Have a look @ online help.


Ivan