Formula Functions > Functions T to Z > TRIM |
This function removes extra spaces from a string and leaves single spaces between words.
TRIM(text)
The argument specifies the string containing the spaces you want to remove.
Accepts string data. Returns string data.
TRIM("" First Quarter"") gives the result First Quarter
This function is available in product version 1.0 or later.
CLEAN | SUBSTITUTE | Text Functions