98.8% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel london - Delimiters
excel london - Delimiters
Resolved · Low Priority · Version Standard
Mon 4 Dec 2006, 12:20Delegate Louis said...
Louis has attended:
Excel VBA Intro Intermediate course
Delimiters
When I try to import .csv docs from the web, Excel doesn't take comas as delimiters. I need to save them as .txt files and open them with Excel with the import wizard, and delimit by commas instead of tabs.
I'd like to be able to set commas as delimiters by default so I can download directly .csv files without saving them as .txt files beforehand.
Thanks
Louis
Mon 4 Dec 2006, 12:57Trainer Richard said...
RE: Delimiters
When you say "import csv from the web", what do you mean. A CSV file is comma separated values, so not sure why you are getting an error. What sort of information are you downloading?
Typically excel remembers the last delimiter setting in the wizard.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Using Alt in Save Dialog BoxWhen you are saving (or opening) a file, try these; |
