| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
delimiters and manipulation
I am using MS2003 Excel and I have a text file that has several elements
separated by commas and quotes (, "")in each of 40,000 records. SAMPLE: "boxer"001,"A", "closet","5656895","door","wood",.....etc What my problem is ( "boxer"001,) the quotes need to be outside the number (001). I can work this out in Excel, but then I am unable to return it to a text file as it was prior to my manipulation. Manual manipulation of the text file (MS wordpad) is out of the question. Any solutions? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Missing delimiters after 15 records | Excel Discussion (Misc queries) | |||
| using multiple delimiters at the same time | Excel Discussion (Misc queries) | |||
| How can I assign delimiters to an excel web query? | Excel Discussion (Misc queries) | |||
| delimiting w/multiple delimiters? | Excel Discussion (Misc queries) | |||
| How do I get carriage returns to not be row delimiters in text fi. | Excel Discussion (Misc queries) | |||
Linear Mode
