View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Terry Pinnell Terry Pinnell is offline
external usenet poster
 
Posts: 46
Default 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