ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Pasting Cells in Excel - Not copying all content (https://www.excelbanter.com/excel-discussion-misc-queries/236964-pasting-cells-excel-not-copying-all-content.html)

Colleen

Pasting Cells in Excel - Not copying all content
 
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?
--
colleen

joel

Pasting Cells in Excel - Not copying all content
 
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)

"colleen" wrote:

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?
--
colleen



All times are GMT +1. The time now is 02:37 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com