| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
CSV and "
indeed. Will contact my host.
In article , "Mike Kiekover" wrote: hmm - I get a blank page when I follow the link |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
| Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
| create links to check boxes marked "good" fair"and "bad" | Excel Worksheet Functions | |||
| Complex if test program possible? If "value" "value", paste "value" in another cell? | Excel Discussion (Misc queries) | |||
| Insert "-" in text "1234567890" to have a output like this"123-456-7890" | Excel Discussion (Misc queries) | |||
Hybrid Mode
