My bad. Yes I ran the code in the main document, not the result. But, when I pasted the code to the resulting merged documents of 80 tables, it did not do anything when ran. I tried sending 1 data set only (the long name) instead of the whole 80 datasets and it was good. I selected another data with short name, sent it to editing, ran the code and it worked. It did not spread the characters out.
It is only when there are more than 1 table in the merged document (results) that the code does not do any changes.