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

www.OfficeArticles.com
www.MyExpertsOnline.com


"Kharpo7" wrote in message
...
I am trying to utilize the trim function in Excel. I enter the "=trim(A2)"
and press enter but leading spaces are still present. There are three
leading
spaces in front of a customer name field and several trailing that I wish
to
remove without having to manually do so. I have tried formatting the cells
as
text or as general with no sucess.

Each time I still get " account name "

Am I missing a step?