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

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

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 *

Are you a Data Enthusiast?

Join us for a ride on your data and automate your stuffs

Business Analytics
Data Analyst
Programming for Data Science
Predictive Analytics for Business