EXCEL format view Issues!... Wile exporting the reports from filter stats! Please Help!
-
Dear all,
I am facing maybe a basic issue when I am trying to export any filter from the BTC stats.
The information, details...numbers etc.. Are opened in my excel desktop, just in one column and not with the same format!Please someone help me?
Many thanks guys!
-
@kevin-pepper Thanks a million Kevin ! I am going to try that at this moment!
-
You may need to change a setting in your version of Excel so it recognises the CSV file comma separators and imports directly into columns. I'm sure you'll find the answer if you Google it.
In the meantime you can select Column A then use Text to Columns in the Excel Data tab, select Delimited then Comma and that should split the data into columns.
Kevin