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!
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.
That little paper clip dude really bugs me. He knows too much...
Me too!! I turn him off - that last paragraph was the propaganda from the Microsoft site. :)
How's the paper coming, Eddie?
The little cartoon character keeps distracting him?
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.
I would write the paper if we had an outlet for it.
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."
Yeah, come on - get cracking on this. You said I could put my name on it too.
What was the topic of this masterpiece again?
Hmmm, 80 Bazillion does figure prominently in this work
Looks like a shaggy Brad W.
Hey, how about that! And I thought he had gone backpacking.
back to original topic, thanks a lot vmeyer. and yes that paper clip is damn annoying ('clippy' is it?)