Excel Tips - anthonyblackham/GIS-Wiki GitHub Wiki

Trim only Leading space:

=MID(A1,FIND(MID(TRIM(A1),1,1),A1),LEN(A1))