I've got a client who was copying text from one worksheet to another,
where the text was being truncated at 255 characters. Both worksheets
were created using Excel 2002. It works fine on my PC with the same
spreadsheets and same version of Excel. I couldn't figure out the
problem for the life of me.

My client figured it out on her own. The problem? She's using dual
monitors, and was copying from a spreadsheet on one to a spreadsheet
on the other. Once she tried doing it without going across monitors,
the text was no longer truncated.

If that don't beat all....