TRIM Excel Formula – How to remove extra spaces or leading spaces in Excel?

Learn Excel Formulas

You must have faced a condition when your data cells contain extra spaces, leading spaces or trailing spaces and you wanted to remove these extra spaces to standardize the data.

So here you may use this amazing excel formula to remove these spaces:

Excel Formula:

=Trim(text)

 

Below is an example where Cell contains extra spaces. So you just need to write a formula in Cell “B2”:

Excel Tricks

Please see below where I used this “TRIM” function to remove these spaces:

Excel Tricks

Hope you like this.

Author:
Excelsirji.com was started with the thought of making people experience easy while working with Excel, data analytics, vba, automations etc.

Leave a Reply

Your email address will not be published. Required fields are marked *

Privacy Preference Center

Necessary

Advertising

Analytics

Other