|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
February 5th, 2009, 12:05 AM
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
February 5th, 2009, 06:24 AM
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
February 5th, 2009, 02:58 PM
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
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
