ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Converting an Excel File to CSV (https://www.excelbanter.com/new-users-excel/154575-converting-excel-file-csv.html)

Jane

Converting an Excel File to CSV
 
Hi,

To convert an Excel file to CSV, am I just supposed to go File Save As and
change the type to be CSV? Is the file supposed to instantly look different?
I've seen a colleague's CSV file, with all fields separated by a semi colon,
but mine is staying exactly the same - in a table. I tried using a Data
Text to Columns function but that didn't do anything, and I could only do one
column at a time. I'm using Excel 2000, which I'm unaccustomed to, so pls
excuse me if I'm missing something completely obvious!

Thanks in advance,

Jane


All times are GMT +1. The time now is 06:59 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com