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: Popular Course in this category
Excel Advanced Training (14 Courses, 23+ Projects) 14 Online Courses | 23 Hands-on Projects | 133+ Hours | Verifiable Certificate of Completion | Lifetime Access
4.8 (7,477 ratings)
Course Price
$59 $399
View Course
Excel Data Analysis Training (12 Courses, 8+ Projects)
Example #2
In the below-mentioned example, I have a dataset in column A, Address in cells “A2” & “A3”, which contains different types of extra spaces, leading spaces, Trailing spaces & extra in-between spaces. Here to remove only the leading spaces (i.e. the spaces towards the left side) in a word or a text in a cell. I can use a combination of formula to get rid of only the leading space in a text. TRIM function is used along with LEFT, FIND and REPLACE functions to remove only leading spaces. Let’s check out the breakup of the above formula; how it works? FIND, LEFT, and TRIM function in excel help out to calculate the position of the first space character in a string (i.e. the spaces towards the left side). And later, when you supply that to REPLACE function, it replaces space with no blank option & thereby removing only leading space in a text. Apply the formula in a cell “B2.” Once you apply this formula, the result you get is shown below.