Customize delimiter character with Excel CSV save-as
If you're willing to move away from Excel, you could try using OpenOffice or LibreOffice to create .csv files. They're both free, they both have most of the functionality included in Excel, and they both allow tabulated data to be saved as a .csv file using any character as a data separator or text delimiter (including the pipe, of course).