Remove leading and trailing spaces from a string.
Syntax Trim(string) Key string A text string or string expression.
The Trim() function can be used in VBA or in an SQL query.
Dim strDemo as String
strDemo = Trim(" The world is everlasting ")
Returns "The world is everlasting"
“The hands of every clock are shears, trimming us away scrap by scrap, and every time piece with a digital readout blinks us towards implosion” ~ Dean Koontz
LTrim - Remove leading spaces from a string.
RTrim Remove trailing spaces from a string.