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”.