Pasting Tables together in Excel - Contents get Cut off
 

I am trying to combine 3 tables together that are all in separate worksheets.
They are all simple, no formulas, macros or anything. The problem is that I
have some cells that contain a lot of text (product descriptions). When I
paste the table in, it only keeps the first 255 characters of each, and
deletes the rest.

Is there any way to fix this? I am sure that it is simple, but I am at a
loss. This have never happened to me. Thank you.