Here’s the trick on how to do it.

Export or Save Excel Files with Pipe (or Other) Delimiters Instead of Commas

image

image

image

image

image