Remove Leading Space from Text String

If cell A1 contains data to be trimmed, then

=TRIM(SUBSTITUTE(A1,CHAR(160),””))  

---