Hi
I used =trim(A1) to remove for the front space and it works. Is there a
way to remove the back space after the characters in column.


--
dziw
------------------------------------------------------------------------
dziw's Profile: http://www.excelforum.com/member.php...o&userid=10422
View this thread: http://www.excelforum.com/showthread...hreadid=562973