TRIM Formula in Excel
Wednesday, Jul 08
commerce curve online accounting course

How to Use the TRIM Formula in Excel

The TRIM formula in Excel is used to remove all unnecessary spaces from the selected text.

Formula explanation:

Text: The cell containing text which you want to modify.


In this example, we have some cells which contain a way too many spaces between the words. We will use the TEXT formula to remove the unwanted spaces.

Formula Implementation:


We can see that the spaces continue to be removed where they are redundant in the sentences, and when we apply the TRIM formula, it results in a proper text formula and a proper text result that has only 1 space between the words.

I hope that helps. Please leave a comment below with any questions or suggestions. For more in-depth Excel training, checkout our Ultimate Excel Training Course here. Thank you!



Learn 10 great Excel techniques that will wow your boss and make your co-workers say, “how did you do that??”
Plus weekly updates to help you learn Excel.

Download the eBook

Contact Us

Please reach out to us with questions and comments using the form.
Commerce Curve.

4 + 13 =