ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   save excel spreadsheet as a csv file (https://www.excelbanter.com/excel-worksheet-functions/9519-save-excel-spreadsheet-csv-file.html)

thelma

save excel spreadsheet as a csv file
 
I need to save an excel spreadsheet to a csv file and not have extra commas
at the end.

JE McGimpsey

one way:

Use the CharacterSV() macro found at

http://www.mcgimpsey.com/excel/textfiles.html

Use a comma as the delimiter.

if you're unfamiliar with macros, check out David McRitchie's "Getting
Started with Macros" at

http://www.mvps.org/dmcritchie/excel/getstarted.htm

In article ,
thelma wrote:

I need to save an excel spreadsheet to a csv file and not have extra commas
at the end.



All times are GMT +1. The time now is 03:44 AM.

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