I saw this question in Twitter this week:

Anyone know a way to get an Excel cell to take over 255 characters w/o converting to pound signs ###? Wreaking havoc on something I'm trying

Here's an example – in the following screenshot, cells B2 and B3 contain the same long string of characters.