Thread: Text Import Wizard - Set Default Options

Hi

I'm using Excel 2007

Every time I use the Text Import Wizard, it seems to deafult certain settings like the Delimiter as Space - is there anyway to change the default settings? I never use spaces in this and its irritrating to have to constantly change this.

Similarly, it always sets the default column type to General, is there an option to change this to Text (or whatever) before importing?

Thanks in advance

Gaz