AFN läuft 5100 rpm bei 37% PWG wiso??? | Posts 32+

Double-click the .csv file.

Save as

.xls

Okay.

Please, thank you, m.

Hi dieselmartin.

Thank you for the response.

I don't just want a .xls file where everything is in one column, but rather a file where all the characters between two commas are written into a separate column, and the commas themselves are removed. So, all the data from the first column should be divided into 16 columns.

So far, I have only found that you need to replace the commas (,) with semicolons () for Excel to split the data into columns. However, some values are automatically reformatted as dates (the month is written in letters). If I set the format to "Standard," only numbers appear, but they are the wrong numbers.
I'm now looking for a way to open a modified .csv file without Excel interpreting the data in any way (e.g., as a date), so that it is displayed unchanged.

Thank you very much for your help.

Best regards, harix84.

ah !! You are English .

Microsoft has come up with something great: the German and English versions respond to commas (,) and semicolons (!

VAG-COM removes commas, and my German Excel just eats them up.

There's a roundabout way involving something like "importing," but I can't find it right now -- sorry.

m;

Hi.

I solved, or rather bypassed, the Excel problem with the help of a friend. I first replaced all commas with semicolons ";" and then replaced all periods with commas. This way, the numbers in Excel are not changed.

Best regards, harix84.