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
Bookmarks