Hi Dave, Marcelo,
I have similar problem too.
I have a cell which has characters more than 255. Eventhough the data is
there, Excel does not allow you to view all the data; it cuts the data for
viewing and also when you print that cell.
If I press F2, I can view all the data but the moment I release the F2 key,
it is back to the view where it cuts the data.
What is the solution to be able to view and print the data more than 255
characters in a cell?
Thanks

"Dave Peterson" wrote:

How are you retrieving that value?

Is the "sending" workbook open or closed?

If you're using a formula to retrieve a value from a closed workbook, then
you'll see that 255 limit. But if you open the "sending" workbook, then
recalculate, you'll see all the text.

Marissa wrote:

Okay, it isn't as bad as I originally thought. It turns out that each cells
seems to have a 255 character limit when it comes to copying data from other
sheets. Is there any way to lift this?

"Marissa" wrote:

Greetings, Excel Community. I hope you can help me with this one.

I was typing some notes in an Excel Spreadsheet, which made for some really
jam-packed cells. However, when I came back to look over it, half my
information was gone, cut short at the 1.5 line mark. Is there anything that
could cause this, and how do I fix it?

--

Dave Peterson