in: Orienteering; The Website;
| # Posted 2006-09-05 21:06:19 | |
| velocity girl: | hey...i'm using excel for macintosh. when i click to export my training log a load of comma separated values come up. how do copy and paste these into excel so that they come up aligned in the right columns? i can work out how to open or save a csv file but can't work out how to import the values in.
thanks in advance! |
| # Posted 2006-09-05 21:23:55 | |
| vmeyer: | Paste the file into Excel. Click on Column A so that the whole column is highlighted. Go to Data, then Text to Columns. Pick Delimited, and then on the next screen, pick Comma as the delimiter. Finish whatever other steps there are and it should be in columns.
For more information about parsing data, click Microsoft Excel Help on the Help menu, type parse data in the Office Assistant or the Answer Wizard, and then click Search to view the topics returned. |
| # Posted 2006-09-05 21:30:20 | |
| eddie: | That little paper clip dude really bugs me. He knows too much... |
| # Posted 2006-09-05 21:35:28 | |
| vmeyer: | Me too!! I turn him off - that last paragraph was the propaganda from the Microsoft site. :) |
| # Posted 2006-09-05 21:37:52 | |
| j-man: | How's the paper coming, Eddie? |
| # Posted 2006-09-05 21:40:25 | |
| vmeyer: | The little cartoon character keeps distracting him? |
| # Posted 2006-09-05 21:46:36 | |
| eddie: | Its like having someone looking over your shoulder while you work. You know what he's thinking: "*I* would have used a macro to do that." or "geez you type slow"
Smart-ass paper clip. Oh, about the paper Clem. I was under the impression that I'd just write the sim and send you the results so YOU could write the paper :) Or maybe we should let the paperclip do it - he thinks he's so smart. |
| # Posted 2006-09-05 21:49:40 | |
| j-man: | I would write the paper if we had an outlet for it. |
| # Posted 2006-09-05 21:52:18 | |
| eddie: | Are you kidding? This will be a hot result. I'm sure the "Journal of Unlikely Results" wll be all over it. Or at the very least, "Nature." |
| # Posted 2006-09-05 22:32:27 | |
| Sandy: | Yeah, come on - get cracking on this. You said I could put my name on it too. |
| # Posted 2006-09-05 22:42:56 | |
| Nev-Monster: | What was the topic of this masterpiece again? |
| # Posted 2006-09-05 22:43:05 | |
| mikee: | I recommend JIR: http://www.jir.com/ |
| # Posted 2006-09-05 22:59:52 | |
| eddie: | Hmmm, 80 Bazillion does figure prominently in this work |
| # Posted 2006-09-05 23:09:03 | |
| vmeyer: | Looks like a shaggy Brad W. |
| # Posted 2006-09-06 00:23:49 | |
| eddie: | Hey, how about that! And I thought he had gone backpacking. |
| # Posted 2006-09-06 02:16:47 | |
| velocity girl: | back to original topic, thanks a lot vmeyer. and yes that paper clip is damn annoying ('clippy' is it?) |
You must be logged in to add a message