Title: Left TRIM in Excel | Remove Leading Spaces Using TRIM Function
Headings: Left TRIM in Excel
Left TRIM in Excel
Left TRIM in Excel (Table of Contents)
Left TRIM in Excel
Leading Spaces:
=MID (A2,FIND (MID (TRIM (A2),1,1),A2),LEN (A2))
= REPLACE (A2,1,FIND (LEFT (TRIM (A2),2),A2)-1,””)
How to Remove Extra Leading Spaces in Excel?
Example #1
Let’s check out the breakup of the above formula; how it works?
Example #2
Let’s check out the breakup of the above formula; how it works?
Things to Remember About the Left Trim in Excel
Recommended Articles

Content: TRIM function is used along with LEFT, FIND and REPLACE functions to remove only leading spaces. = REPLACE (A2,1,FIND (LEFT (TRIM (A2),2),A2)-1,””)
How to Remove Extra Leading Spaces in Excel? Let us discuss How to Remove Extra Leading Spaces of a Text String in a Cell with the help of or combination of FIND, MID, TRIM & LEN excel functions OR LEFT, FIND, REPLACE & TRIM functions. You can download this Left Trim Excel Template here – Left Trim Excel Template
Example #1
In the below-mentioned example, I have a dataset in column A, i.e. Address in a cell “A2”, which it contains different types of extra spaces, leading spaces, Trailing spaces & extra in-between spaces; here, I need to remove only the leading spaces (i.e. the spaces towards the left side) in a word or a text in a cell. In the above example, Address in cell “A2” contains duplicated and triplicated spaces in between a word so that it makes sense to read your data better & present it. Here, I need to only remove leading extra space (i.e. the spaces towards the left side), retaining extra spaces in between a word. To use a combination of formula to get rid of only leading space in a text with the help of or combination of FIND, MID, TRIM & LEN excel functions. Let’s check out the breakup of the above formula; how it works?