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:

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