Question: how to save excel file as csv pipe delimited?
Answer: Browse to the folder where you want to save the new file in the “Save As” window. Enter a name for the new pipe-delimited format file in the “File Name” field. Click the “Save as Type” drop-down list and select the “CSV (Comma Delimited)” option. Click the “Save” button.