[RESOLVED] Format Cell "Wrap Text" problem
hi guys, i bumped to this problem..any input is greatly appreciated...
i format the cell to "Wrap text" so it can contain all my data within one cell...
the data i post is not the actual data i have, just for illustration / clarity purposes...
i'm using excel 2k3
here's the problem...
just for example:
one cell contains this data..
Code:
1. The quick brown fox 2.The quick brown fox
3. The quick brown fox 4. The quick brown fox
5. The quick brown fox 6. The quick brown fox
7. The quick brown fox 8. The quick brown fox
9. The quick brown fox 10. The quick brown fox
11. The quick brown fox 12. The quick brown fox
13. The quick brown fox 14. The quick brown fox
i have two files, book1 and book2.
if the said data, i copied in workbook (book1) either on a different cell or another sheet
data is copied over completely..
but if i copied the said data to another workbook that is open (let's say book2)..
the problem starts.. the whole data is not copied over..
it will copy only these data:
Code:
1. The quick brown fox 2.The quick brown fox
3. The quick brown fox 4. The quick brown fox
5. The quick brown fox 6. The quick brown fox 7.
The quick brown fox 8. The quick brown fox 9. The quick brown fox
10. The quick brown fox 11. The quick brown fox 1
other data is missing....
so is this a limitation for format "Wrap text" or what?
Re: Format Cell "Wrap Text" problem
1) Yes there is a limitation but your data in very well within that limitation
(Length of cell contents (text) 32,767 characters. Only 1,024 display in a cell; all 32,767 display in the formula bar.)
2) How are you copying it to the other cell?
3) After copying, manually/programatically resize the columns or row to autofit so that you can se the entire contents...