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.
The pwrTRIM PowerUp function has the following arguments:
string – Required. This is the text that will have its extra spaces removed.
pwrTRIM will return the text without leading or trailing spaces and multiple consecutive spaces within the string will be reduced to a single space.
=pwrTRIM(" Text to trim ")
Returns “Text to trim”.