TRIM Function

Office 2013 and later

Last modified: March 09, 2015

Applies to: Office 2013 | Visio 2013

In this article
Syntax
Remarks
Example

Removes all space from text, except for single spaces between words.

TRIM (text)

Parameters

Name

Required/Optional

Data Type

Description

text

Required

String

The text from which you want to remove spaces.

Return Value

String

You can use the TRIM function on text that you have received from another application that may have irregular spacing.

TRIM ("January 1, 2003 ")

Returns "January 1, 2003".

Show: