separated by a semicolon

**Kiluk** · 04-17-2013, 06:54 AM

Welcome.
Please help change the macro so that the csv file was separated by a semicolon rather than a comma as it is now.

My macro

Please Login or Register  to view this content.

kiluk

**hamjam** · 04-17-2013, 04:05 PM

Hello
As there is no Excel file export to separate values by semicolon, I suggest you use a text editor - for example notepad.
Open the file, go to edit and do a replace "," with ";"
Should take you no longer than 1 minute to resolve.

Regards

**Kiluk** · 04-18-2013, 02:04 AM

thank you.

Unfortunately, your solution will not work because I need to have 100,000 rows in the xls file to csv file 30.
Kiluk

**hamjam** · 04-18-2013, 02:38 AM

Hello Kiluk
I would not reject that solution because of size, I created a sample spreadsheet consisting of 5 columns and 200,000 rows, i.e. 1 million records and it worked just fine with trusty old notepad.

Regards