Removes leading and trailing spaces, such as whitespace and non-breaking space before and after the text. USE TRIMENDS on text strings that you received from another application, and that may have extra spacing before and after the strings.
Note: TRIMENDS preserves spacing within the text string. To alter spacing within the text string, use the TRIM function. For more information, see TRIM function.
Text The string from which you want spaces removed.
=TRIMENDS(“ Record sales “)
Removes leading and trailing spaces from text in the formula (“Record sales”)