How to Export data from Excel 2010 to pipe delimited text file

Perfect ! you've just saved my life ! Thx !

Thank's a lot brodah...

Thank you! Just what I needed.

nice knowing that what is always been there (csv options like separator and delimieter) as been removed from excel .. M$hit is always going worst .. swicth to linux

Will not work if file contains comma.

Super Sir..Wonderful.. Perfect.. This is what I exactly wanted to convert the data from one delimited to another, like Tab to Pipe symbol, and comma delimited to Pipe or Tab... Thank you so much..

and now that I have done that, how can I continue to utilize formulas in other excel files? or will I need to switch back each and every time after saving a pipe delimited file?

2018 and I still can't believe it's this difficult to export Excel data with a custom delimiter. Good video though

how does this work if your text field already has a pipe in it?

THANKS BAWS!!!

Great video! Thanks!

Very poor solution. So every time i have to go to regional settings and change them? This is not useful at all

Excellent video! Saved my bacon.

Brilliant! Thank you for taking the time to make this video for us minions!

You are awesome

This is a great video! Never thought of it. But there is a reason why - the Excel developers who thought to dynamically grab the list separator from regional settings, but NOT dynamically change the extension of the file. Therefore, no matter what delimiter you choose (pipe, hash, question mark, etc.), the C from CSV will always mean COMMA. :)).

what am I doing wrong? there are no commas no pipes, text has only spaces.

2021 still working
Thanks a lot sir

Brilliant, thank you.

Useful

That is a csv not a txt file