| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Saving txt files with quotation mark delimiters
I have a fixed width data file and need to convert it to a csv file with
quotation marks and commas a delimiters. I thought there was an easy way to do this in Excel. I open the file with excel and I can define fields but I cant figure out a way to save the data with quotation marks around the files separated by commas. Is there any easy way to do this. I have 8 files to do this with containing about 20-25K records each. Thanks |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Saving txt files with quotation mark delimiters
See http://support.microsoft.com/kb/291296 for a macro...
"slipstrm" wrote: I have a fixed width data file and need to convert it to a csv file with quotation marks and commas a delimiters. I thought there was an easy way to do this in Excel. I open the file with excel and I can define fields but I cant figure out a way to save the data with quotation marks around the files separated by commas. Is there any easy way to do this. I have 8 files to do this with containing about 20-25K records each. Thanks |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Saving txt files with quotation mark delimiters
Thank you sheeloo.
"Sheeloo" wrote: See http://support.microsoft.com/kb/291296 for a macro... "slipstrm" wrote: I have a fixed width data file and need to convert it to a csv file with quotation marks and commas a delimiters. I thought there was an easy way to do this in Excel. I open the file with excel and I can define fields but I cant figure out a way to save the data with quotation marks around the files separated by commas. Is there any easy way to do this. I have 8 files to do this with containing about 20-25K records each. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how can I create a csv file with quotation delimiters & commas | New Users to Excel | |||
| Single Quotation mark in CSV | Excel Discussion (Misc queries) | |||
| Single Quotation mark in CSV | Excel Discussion (Misc queries) | |||
| how to put quotation mark in each cell of the column | Excel Worksheet Functions | |||
| Single or Double Quotation Mark and it comes up twice | Setting up and Configuration of Excel | |||
Linear Mode
