Complete Excel VBA Course

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:

Complete Excel VBA Course
=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.

Similar Posts

Leave a Reply

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