MS Excel export allows a csv (comma delimited) export. Is it possible to export my files from excel to .txt or csv files (all the cells in my excel file) delimited by "|" (without the quotes) instead of commas.
Yes, it is possible. In MS Excel 2007, you would go to your options, and visit the detailed settings tab. Uncheck the box for using system delimiters (which should be showing the comma character). Then, just enter the pipe character or whatever you want as your new default column delimiter. With this setting change, the pipe character will be used instead of the comma when you export as CSV. You should have a look at this page.