 |
 |
|
 |
 |
|
 |
 |
 |
Description: Removes all spaces from text except for single spaces between words. Use TRIM on text that you have received from another application that may have irregular spacing.
Syntax: TRIM(Text)
Text is the text from which you want spaces removed.
Example:
TRIM(" First Quarter Earnings ") = "First Quarter Earnings" [removes leading and trailing spaces from the text in the formula]
© 1992-2019. HBM Prenscia Inc. ALL RIGHTS RESERVED.
 |
E-mail Link |