Get around character limit in excel paste link

Can anyone please suggest a way to get around the character limit when paste linking one workbook to another ? (excel 2010)

The cell value is all text, and has gone over the limit so when "paste linked" the text does not completely copy over and the last sentence is cut off part way through.

maybe in 2 times with left & right ?


kind regards
Leo