How to Remove Spaces to the Left of a Text String in Excel

via https://youtu.be/L0OWtP-Yvys

In this video, I show you how to remove spaces from the left of a string of text in Excel using FIND, MID & TRIM + LEN.

If this does not work for you, there may be non-breaking spaces in your document caused by copying text from a website. Here’s how to fix that: https://youtu.be/7YKR3ifmleo?t=155

Use this formula, replacing X2 with the cell you want to trim: =MID(X2,FIND(MID(TRIM(X2),1,1),X2),LEN(X2))