View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Mike Kiekover Mike Kiekover is offline
external usenet poster
 
Posts: 7
Default csv & " (re-post)

that is soooo cool - the "Text files with no modification" macro work great.
One little quirk - It doesn't like the cells in the first column to be
blank. I got rid of the blank column and it did exactly what I needed. With
the blank column it only exported the first row.

Mike


"Dave Peterson" wrote in message
...
The site is back up now.

Mike Kiekover wrote:

Still having trouble with this. Links refered to in replies from the
original post were not available, and I can't seem to reply to continue
the
original posting.

I have text which includes " <inch marks. When I saveas csv, and open
with
notepad there are additional " added to the text. If I re-op in excell I
do
not see the additional ". For instance, a cell with < 6" shows in csv
opened with notepad as < "6""" . same csv re-opened in excel still shows
original format < 6" .

Any way to NOT get additional quotes to show when opening in Notepad?

--
Posted via a free Usenet account from http://www.teranews.com


--

Dave Peterson




--
Posted via a free Usenet account from http://www.teranews.com