| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do you use a comma as the line terminator when saving to csv?
I can save an excel worksheet as a .csv file. However, I expected the line
terminator to be a comma. It appears that there is not any line terminator. Is there any way to set the line terminator to a comma? -- J |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do you use a comma as the line terminator when saving to csv?
"Jaybird74" wrote in message ... I can save an excel worksheet as a .csv file. However, I expected the line terminator to be a comma. It appears that there is not any line terminator. Is there any way to set the line terminator to a comma? -- J Are you trying to import the csv into another program which REQUIRES a line terminator? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do you use a comma as the line terminator when saving to csv?
The standard line terminator in a csv file is a carriage return. What are
you doing that requires a comma? Anyway, you will have to open the csv file in word and replace Paragraph Mark with ,Paragraph Mark. (click on More and Special to get the paragraph mark) "Jaybird74" wrote: I can save an excel worksheet as a .csv file. However, I expected the line terminator to be a comma. It appears that there is not any line terminator. Is there any way to set the line terminator to a comma? -- J |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change line in Chart | Charts and Charting in Excel | |||
| coloring overy other line without doing so line by line | Excel Worksheet Functions | |||
| Problems with line tool when saving as a webpage | Excel Discussion (Misc queries) | |||
| Line chart - date line association gone mad! | Charts and Charting in Excel | |||
| Macro - Skipping a line | Excel Worksheet Functions | |||
Linear Mode
