How to save xls to pipe delimiter file without code

1) Save your worksheet to .csv
2) Open the .csv file in notepad
3) Use Find-And-Replace in notepad to replace all , to |

Important note: You should replace the commas in your real content to some other symbol (suggestion:#,~) first so that you don't replace them with | in step 3. You then might want to run a step 4 (find-and-replace in notepad to replace all # to ,)