open in excel as space separated file
open in excel as space separated file
(OP)
hello
i am stuck on an excel issue when opening space separated text files.
i have many text files that i need to open in excel as space separated files..... i manually click thru the OPEN> etc etc etc tabs to do this.
can the excel defaults be changed to automatically be set to open all *.* files as space separated files?
thanks for any guidance.
daveleo
i am stuck on an excel issue when opening space separated text files.
i have many text files that i need to open in excel as space separated files..... i manually click thru the OPEN> etc etc etc tabs to do this.
can the excel defaults be changed to automatically be set to open all *.* files as space separated files?
thanks for any guidance.
daveleo





RE: open in excel as space separated file
RE: open in excel as space separated file
Sean
RE: open in excel as space separated file
are you sure about that URL ??
daveleo
RE: open in excel as space separated file
Several years ago I switched from the spreadsheet assistant to ASAP utilities and never regretted it.
Cheers,
Joerd
Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.
RE: open in excel as space separated file
Looks like a simple typo by sean01.
Try this url for spreadsheet assistant:
http://www.add-ins.com/
RE: open in excel as space separated file
daveleo
RE: open in excel as space separated file
If you import a text file, the settings will stay the same for your session. So next time you do the import, you can click Finish right away - until the next day.
Cheers,
Joerd
Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.
RE: open in excel as space separated file
that work just fine
thanks.
daveleo