I’m trying to manipulate data in a txt file (*.cfg) in Excel and then save it as pure text. I’m having problems using “save as” from Excel because it insists on puting some of the text in quotes “”. Here is an example:
It doesn’t work in this case. That is the nature of the problem. Excel is storing each cell in the .txt file, separating cells in the same row with a comma. When the text in a cell contains a comma, Excel must enclose the cell in quotes to ensure that any program reading the data will also interpret it as a single cell, rather than two cells separated by the comma.
You cannot write a macro that will copy then paste into an application that does not support VBA (you could copy and paste into Word with a single macro, for example, but not into Notepad).
When I see people having trouble with something like this I usually go back to the beginning. Why are you manipulating this data in Excel? What are you doing to it? From what is shown in the OP it looks like you are not treating the data as numbers in separate cells, but as lines of text. Excel might not be the best solution.
Can I fix this by using TAB separated and making sure there are no tabs in the text? Edit: Apparently not as there don’t appear to be any tabs but the problem still occurs in tab separated .txt.
A good idea.
I’m trying to make a spreadsheet that can edit the aircraft configuration files from Microsoft Flightsim 2004. Specifically I want to be able to tell it how many passengers and cargo I want on my aeroplane. There is a small amount of data manipulation, no more complicated than simple arithmetic and multiplication. I’d like it to use Excel, because I’d like to have it in the same workbook as my fuel calculations.
I have no problems with any of it except for saving it. At the moment I’ve taken don’t ask’s suggestion and am just copy/pasting.
That would be almost perfect except it ends up with lots of these "" which seems to “break” the file. Any ideas on what would cause those? I tried copying some into this post but they came out as line breaks.
Edit: the symbol that should’ve been in the quotes is a square character that you sometimes see when you don’t have the correct font installed.