TRIM
The TRIM function removes leading and trailing spaces from a text string while retaining spaces between words. This function is commonly used to clean and standardize text values.
Syntax
TRIM(value)Arguments
value: The text string to trim.
Return value
Returns the text string without leading and trailing spaces.
Example
TRIM(" Forecast Report ")Returns Forecast Report.
Excel equivalent
Last updated
Was this helpful?