I didn't before you asked but now I have. For both the the origination column
and the formula column they are "General" for Text alignment and 0 for
Indent. I toggled the alignment to left, center and back to left but there
still appears to be the 3 spaces after hitting the left align button.

"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?
*******************
~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?