I tried your first suggestion and that didn't solve it.. I am not sure how to use a macro?

Its weird because sometimes when I copy and paste a link, it will not do the extra space, while sometimes it will..

Any other suggestions?