Excel - Long text cells copy & paste as '#'
Really confusing me this one, it's quite specific but I'm hoping there's a fix.
If you have a cell containing a long chunk of text (appears to be over 250 characters), in Excel it will display as a line of pounds ('#'), until you click in to the cell at which point you can see the actual text.
If you copy these values and try to paste them as text in another spreadsheet (via paste special), rather than copy the actual text, it copies a line of pounds instead.
Anyone know how to fix this?
If it helps, my situation is trying to transfer reports from XLS spreadsheets in to formatted XML sheets for SIMS import (don't ask!)