excel london - Delimiters

The UK's most regular instructor-led training courses.
Training information: excel london · Excel advanced · Microsoft Excel Training
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version Standard

Delimiters

Louis has attended:
Excel VBA course

by - delegate Louis [3 posts] (2006 Dec 4 Mon, 12:20) Reply

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

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Jul 8 Tue	Bloomsbury	0	FULL
2003/XP	2008 Jul 8 Tue	Bayswater	1	book now	£195	£205
2003/XP	2008 Jul 9 Wed	Bloomsbury	3	book now	£210	£215
2003/XP	2008 Jul 15 Tue	Bloomsbury	3	book now	£210	£215
2003/XP	2008 Jul 15 Tue	Tooting	0	FULL
2007	2008 Jul 16 Wed	Bloomsbury	7	book now	£202	£224
Full Schedule: See all 160 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

RE: Delimiters

by - trainer Richard platinum contributer [761 posts] (2006 Dec 4 Mon, 12:57) Reply

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.

· Excel Advanced Courses Ease the Frustration of Learning Complex Tasks
· 3 Reasons why Your Small Business Office Needs Microsoft Excel Training
· Tips to Facilitate Printing of Excel worksheets
· Customized Financial Excel Courses in London
· A Beginners Guide To Formulas In Excel