Set Default Import Data Delimiter to Comma
Posted on 2009-04-10
When importing data manually from text files using the Text Import Wizard the default delimiter is 'tab'. I would like to set my Excel default to 'comma' so that I can just bring up the import dialog and click 'Finish' rather than having to click to change the delimiter. Also, if it is possible to select delimited rather than fixed width as a default, and to set whether or not to treat multiple delimiters together as one that would be even better.
Showing me a way to do this manually through the interface would be best. But if it is something I can run as an addin or start-up macro that would be OK too.
This is just to improve efficiency. There is no way to automate this because I want this to be the default for a wide variety of files. Some of the files have a .csv extension while others have a .txt extension. The files are generally number tables so commas work fine. There is no reason to do a string replace on all the files to convert commas to tabs.
Is this possible in Excel 2007?