How to Remove Spaces to the Left of a Text String in Excel + Fixing Non-Breaking Spaces

In this video, I show you how to remove excess spaces to the left of a text string in Excel using a combination of FIND, MID & TRIM + LEN. I also explain a solution if this formula does not work for you due to non-breaking spaces which happens when you copy text from the internet (use find and replace where you find all Unicode non-breaking spaces and replace with a standard ASCII space).
Use this formula, replacing X2 with the cell you want to trim: =MID(X2,FIND(MID(TRIM(X2),1,1),X2),LEN(X2))
Don't forget to subscribe to my channel for more tutorials!
Check out my website at simplesoftwaretutorials.com
Video recorded using Screencast-O-Matic (www.screencast-o-matic.com)
Thanks for tuning in!