Customize delimiter character with Excel CSV save-as

Is there any way to do this? I need to use a pipe "|" as my delimiter. On Windows you can change this during the export. On Mac I haven't found a way. As a side note, my files have commas in the data itself.

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).

Well, wouldn't you know it, I don't need this functionality anyhow. Excel is smart enough to detect cells that have commas in them, and in this case, it will automatically delimit the text with surrounding double quotes. I wasn't giving Excel any credit!