ExcelBanter - Save a csv or text file in Excel 2000 with choice of separator

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Save a csv or text file in Excel 2000 with choice of separator (https://www.excelbanter.com/excel-discussion-misc-queries/109085-save-csv-text-file-excel-2000-choice-separator.html)

bazza1

Save a csv or text file in Excel 2000 with choice of separator

Hello, I want to save a csv or text file from excel 2000 but using |
as separator. However I can not find option to chose the separator and
it defaults to ,
any advice welcome

All times are GMT +1. The time now is 04:40 AM.