Does anyone know if there is a function to remove or replace space
within a string variable in VBA. I want something similar to the TRI
function that also removes spaces from middle of the string as well a
the ends.

Thank

--
blatha
-----------------------------------------------------------------------
blatham's Profile: http://www.excelforum.com/member.php...fo&userid=1944
View this thread: http://www.excelforum.com/showthread.php?threadid=39850