Create Pipe Delimited Files Using MS Excel

In the automotive aftermarket community the exchange of electronic parts data when not in ACES or PIES XML is usually in a Pipe delimited format.

The most common desktop application to manipulate data is Microsoft Excel. Unfortunately Excel does not have a native way to specify a delimiter. You have .CSV, Tab and a few others none of which are Pipe.

This neat trick will show you how to create Pipe delimited files using MS Excel.

Be sure to watch in HD!

Like and share! Use the comments to request custom videos.

[jmflame]

Thanks, Sir !!! This is how the world always evolve, people sharing knowledge, Thanks Again !!!

[luffyy]

I have a CSV file, in which two columns are there seperated with pipe, but when I click it is on same cell, how can I divide the two column, as I want to take sum of second column

[TheAnnamarie]

Taking it a step further... how would you add field enclosure: {

[andrewburton]

Sir, you just save me an hour of changing, to | manually. Thank you!

[sammohit]

Create videos with brief over view of all sort file like, csv, xml etc.

[edtrembicki-guy]

Excellent hack! BTW, were you ever a BBC presenter?

[sabariyyappa]

It helped me. thanks for such a simple explanation.

[shoebkhan]

Thank you much!! This worked Cha-Cha Smooth..