Export to CSV or TXT file using a custom or specific delimiter
Add the feature to export an excel file to a .CSV or .TXT file with custom/specific delimiters.
So if you want to create a pipe file, you can select the delimiter ( | ) and there you go, you have your pipe file from excel.
Agree, it's too cumbersome to go and change your regional settings just to specify a custom delimited should be an option when saving as CSV in excel.
Jason Coulls commented
I've +1 on the vote here. Just to explain to the Excel team where this is really important - Health data, especially HL7 data - which is peppered with pipes and currently my only reliable solution is to export as a tab delimited text, then (because VS Code can only find/replace 10,000 items at a time), I load the text file into XCode where I can do 300,000 find/replaces.