I'm trying to save an Excel 2007 file as a pipe-delimited text file but in the Save As list, I see only tab-delimited and csv options. How do I go about specifying the delimiter, which as I recall was possible in earlier Excel versions via a wizard?
Excel Export – Specify Delimiter for Excel 2007 Export
exportmicrosoft excel
Best Answer
From this page:
Now exporting as CSV in Excel will produce pipe-delimited files.