View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Auric__ Auric__ is offline
external usenet poster
 
Posts: 538
Default importing cvs file!!

kima wrote:

I get some number from a measuring station i a cvs file. But they have
made a programming fault making some of the negative results arriving
with "--" instead of "-"

[snip]
SOLVED IT … had to import cvs to A:A (TEXT) then Replace "--" with "-"
and then use text to columns.


In the future, just open the CVS file in your text editor of choice and do
the replacing there *before* opening in Excel.

--
So, you're saying that if I can trick all the other mindless drones
into believing that I subscribe to their arbitrary moral framework,
they'll just leave me alone?