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: We need to create a formula in excel to remove only the leading space in a text; currently, I have created two formula’s where it removes only the leading spaces, irrespective of trailing spaces & extra in-between spaces present in it. 1. We can get rid of only the leading space in a text with the help of or combination of FIND, MID, TRIM & LEN excel functions. =MID (A2,FIND (MID (TRIM (A2),1,1),A2),LEN (A2))
2. 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.