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.

Syntax

TRIMENDS(text)

Text    The string from which you want spaces removed.

Example

Formula

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 skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

What affected your experience?

Thank you for your feedback!

×