ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   EXCELs test wizard determined data is delimited - since (https://www.excelbanter.com/excel-discussion-misc-queries/218087-excels-test-wizard-determined-data-delimited-since.html)

CommenTerry

EXCELs test wizard determined data is delimited - since
 
I opened a xls file with MS Excel that's been opened and reopened each week
for the last year. Now, I click to open and get a notice - that data is
delimited. How do I return things to "normal"? I can see no regular numbers
or words, just gobbledy gook.


David Biddulph[_2_]

EXCELs test wizard determined data is delimited - since
 
An xls file doesn't need the text wizard to open it.
What is the file extension? [Make sure that in Windows you are viewing the
extensions on files, and not fooling yourself with something like
something.xls.txt which (if you are hiding extensions) might look as if it's
called something.xls and actually be an Excel file rather than a text file,
burt would be treated as a text file.]
Try opening the file in Notepad, and see whether you can read it (in which
case it's text) or whether it looks like gobbledygook there. If the latter,
take a copy of the file and change the extension from .txt to .xls.

Another option if you are struggling is to go back to the backup of your
file.
--
David Biddulph

"CommenTerry" wrote in message
...
I opened a xls file with MS Excel that's been opened and reopened each week
for the last year. Now, I click to open and get a notice - that data is
delimited. How do I return things to "normal"? I can see no regular
numbers
or words, just gobbledy gook.





All times are GMT +1. The time now is 08:38 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com