Im making these large table that are usually created from other tables, they all contain hyperlinks and general text.

Problem: When I copy and paste, the hyperlinks are being pasted into other cells besides the one they are intended. I'll copy like 200 rows, 1 column and say there will be 10 empty cells, 4 linked cells, 10 empty, 4 linked.... and so on down the column.

when i go to paste in the new table, all cells are linked up, even if there is no visible text.

How do i fix this, or better yet prevent it.

I've been using paste special, html paste and it still occurs time to time.