All of contents in cell don't link
 

On a regular basis, I link certain cells in W1 to W2. I copy these linked
cells from W2 into W3 and paste only the values into W3 so I can sort them.
I noticed that when I did this a couple of months ago, all of my text from
the cells got transferred. When I did it today, I noticed that not all of
the text from the same cells was getting transferred. I hope this isn't too
confusing to understand... The cells in question do have quite a bit of
text, but some have less and the contents still get cut off. Can anyone help
me understand why, so I can link all of the info I need?

Thanks so much :)