How do I recover text that was truncated/ deleted in Excel?

C

CNK

Does anyone know how to recover text that was truncated/ deleted in Excel?
Is there a way to do this?

All cells that had text over 255 characters (with spaces) were truncated and
the text appears to have been deleted. I think this may have occurred when
Excel asked what version of Excel I wanted to save the workbook under.
 
D

Dave Peterson

If you saved the workbook in a pre-xl97 format, then you'll have to go back to
one of your backups -- the data is lost.

xl97 extended the number of characters per cell to 32k (about) from 255.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The picture is too large and will be truncated 1
Why is Excel truncating my text to 255 characters? 4
Find truncated cells 1
How do I set focus (and select text) on a text box on a modeless userform? 0
Text Truncated after Paste link in Excel 2002 3
Can I recover a file that was saved after I press replace? 1
How do I recover a deleted Excel 2007 work sheet tab? 2
Display bug in Word: tables disappearing on copy and paste of text with bullet points into table 2

Top