converting a .xls file to a | or ~ delimited

Please Sign-in or Register to vote

For Creating Pipe (|) demited file from Excel Follow the Steps.....
1)Go to Control Panel(Regional language) and Change the List separated comma (,) to Pipe (|).
2)Apply and Ok.
3)Open Excel File that to be create as Pipe (|) Delimited.
4)SaveAs Comma Separated File (.CSV) Format.
5)Open that CSV file in Notepad and replace Comma to Nothing and Save.
6)Change the List Separator from Pipe (|) to Comma (,) from Control Panel.