In addition to the TRIM function, you may want to used the CLEAN
function on the data table being imported from the other application.
--
rsenn
------------------------------------------------------------------------
rsenn's Profile:
http://www.excelforum.com/member.php...o&userid=29050
View this thread:
http://www.excelforum.com/showthread...hreadid=492880