Sweet, Harlan. :)
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"Harlan Grove" wrote in message
oups.com...
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)))