TRIM(string)

Returns the text string removing leading and trailing spaces (String).


stringThe text string (String).

REMARKS
* If "string" is Null, then Null is returned.
* You can use the TRIM$ function to return a String data type instead of a Variant/String data type.
* The equivalent Excel function is Application.WorksheetFunction.TRIM
* The equivalent .NET function is Microsoft.VisualBasic.Strings.Trim
* For the Microsoft documentation refer to docs.microsoft.com

Trim("   some text   ") = "some text" 
Trim(" hello ")="hello"

© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited Top