Hi,

Merry Christmas and Happy New Year.

I import a report in Excel format from another business system, but there
are always 6 empty spaces behind a column of reference say HG2145______.

I try to use =TRM() to eliminate the trailing spaces but always fail. I get
back the same thing. I could only do this by using =LEFT(A2,6)

May I know why and is there any other ways of getting what I want ?

Thanks

Low


--
A36B58K641