Hi,

I want to save an Excel sheet as txt file. I want to separate all values with a pipe delimiter but I don't see a way to do it. I can choose "save as" comma or tapstop separated tabstops file.

I don't want to write a macro for this. So if it is not possible in an easy way, please tell me.