TRIMENDS function

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.


Description (Result)

=TRIMENDS(“ Record sales “)

Removes leading and trailing spaces from text in the formula (“Record sales”)

Top of Page

Need more help?

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.