How to Use TRIM Function

The TRIM function is to remove the extra spaces except for the single spaces between words.




Text is required, the text that you need to remove spaces.


The TRIM function cannot remove the nonbreaking space character  , which is commonly used in Web pages.

Example: Remove extra spaces in cell A3.

= TRIM(A3)

The extra spaces in the middle in cell A3 were removed, returning the result "How to Use Trim Function".

Download: TRIM Function

Leave a Reply