|
Perhaps this will help you as well:
I have to open csv files in my company in excel and get very strange views, while my colleagues get a proper structure. As we cannot find a better answer and we are working global, the assumption is that the different result is due to local settings. We did not find which but I found a workaround.
I use the same workaround for my calibre catalog to get rid of the extra rows in comments.
Here are the steps:
- open csv with notepad+, mark all and copy ctrl A/C
- open excel, paste ctrl V
- mark first column, data, text to columns, separate, by comma, finish (my excel is german, so I tried to find translation) = bad result is ok
- open new tab in same excel, paste again = oh wonder, perfect view
This works not after closing excel.
|