The easiest way to remove that annoying space that sometimes appears in the beginning of a cell in an Excel spreadsheet.
Just use the TRIM formula and it will remove any spaces that are not single spaces between words.
If your text is in cell A1, just enter this command in any cell, then copy the result back to A1
+TRIM(A1)
The following screen shot indicates a few examples
58.1 - 813,620
↓ Scroll down for Comments ↓