Need to change the seperator from COMMA to SEMICOLON

[Allwinv]

Hi Excel Experts,

In my project, i got some excel file from End users. For loading the excel file to my SAP BW, I need to change it to CSV file.

After changing, i am opening the file in Textpad, the seperator is COMMA. I just want to make it as SEMICOLON as seperator.

Can you please suggest, is there any settings available to perform this.

Thanks & regards,
Allwin

 

[Joe4]

One easy way.

Open in NotePad.
Go to the Search menu and select Replace.
Replace all commas with semi-colons.

 

[Allwinv]

One easy way.

Open in NotePad.
Go to the Search menu and select Replace.
Replace all commas with semi-colons.

Thank you. But some of the cells having data with comma. So this will not work in my case. Can you please suggest any permanent settings from comma to semicolon.

 

[Joe4]

Thank you. But some of the cells having data with comma. So this will not work in my case. Can you please suggest any permanent settings from comma to semicolon.

Are text qualifiers being used (i.e. double-quotes surrounding the data entries that have literal commas that aren't delimiters)?
If so, then you can open the file in Excel, and then use this VBA code here to save it with semi-colons as delimiters: VBA code: Save an excel file as semicolon separated values

If text qualifiers are not being used, then there is no way for anyone or system to differentiate literal commas from the delimiters.

 

[Allwinv]

Thank you Joe. I will Cheviot and update you