TRIM function

Category: Text
Introduced: Excel 2003

Summary

Removes spaces from text

Syntax

TRIM(text) The TRIM function syntax has the following arguments:
• Text Required. The text from which you want spaces removed.

Example

=TRIM(" First Quarter Earnings ")

Microsoft Support Page

https://support.microsoft.com/en-us/office/trim-function-410388fa-c5df-49c6-b16c-9e5630b479f9

Back to Functions