Pasting Cells in Excel - Not copying all content

[colleen]

I'm copying and pasting cells from one worksheet into another and some of the
cell content is getting cut off - its not copying over the entire content of
the cell. Help?

 

[Joel]

The data will cut off after 1024 characters. You may have to copy cells wih
a lot of data using the f(x) box at the top of the worksheet. select the cell
you want to copy and then highlight the character in the f(x) box and copy
(cntl-c). then select the destinnation cell and paste the data into the f(x)
box. See if this solves the problem.

It may not be the final solution but I need to see if the problem is the
lenght of the data.

You can also test the length of the cell using the following formula

=LEN(A1)