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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
Back
Top