so it was a simple fix just took some time to get my head around the code and work out what i needed to search for and as soon as i saw a solution i knew it was going to fix it.
i had already tried putting quotation marks in but they were inside the {} not outside.

Solution attached


https://www.dropbox.com/s/uvphylqtog...lMergeFix.PNG?

I had one side effect but that was solved by running my table joiner macro twice.