Anne Troy wrote...
Have you selected the cells, then hit Format-Cells, Alignment tab. Make sure
there's no indent, and that they're aligned left?
....

Alignment might be a problem, but assuming the OP does know s/he's
talking about, it's more likely the 'spaces' are HTML nonbreaking
spaces (decimal character code 160) rather than ASCII spaces 9decimal
character code 32). The OP may have better luck changing the formula to

=TRIM(SUBSTITUTE(A2,CHAR(160),CHAR(32)))