Wednesday, June 29, 2022

TRIMENDS function [MS]

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

No comments:

Post a Comment

Search This Blog

Work in Excel for the web [MS]

Work in Excel for the web Excel for the web More... Less ...