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:



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.

Similar Posts

Leave a Reply

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