Title: TRIM Function - Formula, Examples, How to Use TRIM in Excel
Headings: TRIM Function
TRIM Function
What is the TRIM Function?
Formula
=TRIM (text)
A few notes about the TRIM Function:
How to use the TRIM Function in Excel?
Example 1
Example 2
Example 3
Click here to download the sample Excel file
Additional resources

Content: Formula
=TRIM (text)
Text (required argument) – This is the text from which we wish to remove spaces. A few notes about the TRIM Function: TRIM will remove extra spaces from text. Thus, it will leave only single spaces between words and no space characters at the start or end of the text. It is very useful when cleaning up text from other applications or environments. TRIM only removes the ASCII space character (32) from the text. The Unicode text often contains a non-breaking space character (160) that appears in web pages as an HTML entity. It will not be removed with TRIM. How to use the TRIM Function in Excel? TRIM is a built-in function that can be used as a worksheet function in Excel.