ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   CSV and " (https://www.excelbanter.com/excel-discussion-misc-queries/131628-csv.html)

Mike Kiekover

CSV and "
 
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


JE McGimpsey

CSV and "
 
Take a look he

http://www.mcgimpsey.com/excel/textfiles.html

In article ,
"Mike Kiekover" wrote:

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?


Mike Kiekover

CSV and "
 
hmm - I get a blank page when I follow the link


"JE McGimpsey" wrote in message
...
Take a look he

http://www.mcgimpsey.com/excel/textfiles.html

In article ,
"Mike Kiekover" wrote:

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


JE McGimpsey

CSV and "
 
indeed. Will contact my host.

In article ,
"Mike Kiekover" wrote:

hmm - I get a blank page when I follow the link


Mike Kiekover

CSV and "
 
I'm still looking for some input on this if available. The link provided in
the other response was not accessable, so nothing to work with yet

Mike

"Mike Kiekover" wrote in message
.. .
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




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


JE McGimpsey

CSV and "
 
In article ,
"Mike Kiekover" wrote:

I'm still looking for some input on this if available. The link provided in
the other response was not accessable, so nothing to work with yet


Try the link again. The server was down:

http://www.mcgimpsey.com/excel/textfiles.html

Mike Kiekover

CSV and "
 
Got it - works great - thanks - great explaination on the web page

"so easy, even a caveman can do it" :)

Mike


"JE McGimpsey" wrote in message
...
In article ,
"Mike Kiekover" wrote:

I'm still looking for some input on this if available. The link provided
in
the other response was not accessable, so nothing to work with yet


Try the link again. The server was down:

http://www.mcgimpsey.com/excel/textfiles.html




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



All times are GMT +1. The time now is 05:27 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com