How to Use TRIM Function

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

Formula:

=TRIM(text)

Explanations:

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

Cautions:

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