Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Parsing text
Message
De
09/03/2004 21:10:38
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivie
 
 
À
Tous
Information générale
Forum:
Microsoft Office
Catégorie:
Excel
Titre:
Parsing text
Divers
Thread ID:
00884678
Message ID:
00884678
Vues:
52
I was wondering whether there was a faster way to do the following. A Web-site offers me a CSV (comma-delimited) version of a certain table (gradebook). I copy on screen (in Internet Explorer), and paste into Excel. Then, I have to go through the parser wizard.

Additional complications arise from the fact that in Latin America, we use comma for decimals, and period for thousands. So, I either have to switch this in the Control Panel first, or search-and-replace in Excel later.

In summary, the steps I use seem quite involved for such a simple thing. Any ideas?
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Répondre
Fil
Voir

Click here to load this message in the networking platform