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: 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. Similarly, this formula is applied in cell B3 to remove only the leading space in cell A3. In the resultant string, you can observe, it has removed only spaces from the left side. Retaining extra spaces in between a word. Things to Remember About the Left Trim in Excel
Apart from these different formula combinations, you can create your own based on the nature of text value & its format. Suppose you text value which contains only leading space (It does not contain any Trailing spaces & extra in-between spaces in the word or text);