Hi Max,

You can use the Trim function to remove leading and trailing blanks (before
and after - not in the middle)
Regards,
Jean-Yves

"MAx" wrote in message
...
I'm running a macro to compare to sets of values, but it's not working
because after one imported strings has a space on the end it.

Grateful for any ideas to get round this problem.