How do I paste a large amount of text into a cell ?

[Guest]

I'm trying to copy and paste excel cells from one spread sheet to another.
The cells contain large amount of text. In many cases only the first two rows
of text are being copied to the target spread sheet. How do I make sure that
all the text will be copied to the target spread sheet?

 

[Peo Sjoblom]

How many characters are you talking about, look in help for specifications
to see how much text a vcell can hold, if within the
specifications you can try to paste into the formula bar