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.