I've came across this a long time ago and the solution I found was to ADD blank colums in-between your data columns in the Excel worksheet, and fill those cells with the | (pipe) character.
When exported as plain text they look the same as a pipe delimited file would.
Hope this helps.
All the best
Shaun
When exported as plain text they look the same as a pipe delimited file would.
Hope this helps.
All the best
Shaun