ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Changing the comma for a semicolon when creating a CSV file (https://www.excelbanter.com/excel-programming/336684-changing-comma-semicolon-when-creating-csv-file.html)

Peter Rooney

Changing the comma for a semicolon when creating a CSV file
 
Hello, all,

Quite simply, is this possible, apart from doing a search and replace on the
resulting CSV file?

Peter Rooney

Changing the comma for a semicolon when creating a CSV file
 
Sorry - should have said "Thanks in advance"

Regards

Pete



"Peter Rooney" wrote:

Hello, all,

Quite simply, is this possible, apart from doing a search and replace on the
resulting CSV file?


Tom Ogilvy

Changing the comma for a semicolon when creating a CSV file
 
You could use Chip Pearson's code that allows you to specify the delimiter:

http://www.cpearson.com/excel/imptext.htm#Export

--
Regards,
Tom Ogilvy


"Peter Rooney" wrote in message
...
Hello, all,

Quite simply, is this possible, apart from doing a search and replace on

the
resulting CSV file?




Peter Rooney

Changing the comma for a semicolon when creating a CSV file
 
Tom,

Thank you very much. For some reason, I didn't get a notification that
anybody had responded, and I only came back in to look today!

Regards

Pete

"Tom Ogilvy" wrote:

You could use Chip Pearson's code that allows you to specify the delimiter:

http://www.cpearson.com/excel/imptext.htm#Export

--
Regards,
Tom Ogilvy


"Peter Rooney" wrote in message
...
Hello, all,

Quite simply, is this possible, apart from doing a search and replace on

the
resulting CSV file?






All times are GMT +1. The time now is 07:23 PM.

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