Displaying CSV file in columns?
I'm a bit rusty, so have forgotten some basics...
Some programs I use allow output of their tabular information in CSV
format for future reference, with semi-colons as separators. How can I
quickly re-display that in the same tabular form please, in Excel
2000?
Ideally I'd *prefer* to view it in my text editor (TextPad), because
that is always open, and fast to use. And that way I can apply a
global replace of ';' by '\t' to insert tabs. That allows easier
viewing, although not consistently lined up, of course. But Excel
doesn't appear to allow such flexibility. Or, more likely, I've
forgotten where it is!
--
Terry, West Sussex, UK
|