PowerUp Description
The pwrTRIM PowerUp function trims extra spaces characters from a string. Leading and trailing spaces are removed. Within a string, multiple spaces are reduced to a single space.
PowerUp Syntax
pwrTRIM(string)
The pwrTRIM PowerUp function has the following arguments:
string – Required. This is the text that will have its extra spaces removed.
Return Value
pwrTRIM will return the text without leading or trailing spaces and multiple consecutive spaces within the string will be reduced to a single space.
Remarks
None.
Example
=pwrTRIM(" Text to trim ")
Returns “Text to trim”.