How to open a CSV file that uses Pipe Delimiters in Microsoft Excel
CSV stands for comma separated file, sometimes we don’t want to use comma’s in a CSV file and decide to rather use a Pipe Delimiter | especially in cases where one of the columns contains a paragraph with comma’s in. Open Office provides us with a option to choose the Delimiter when opening CSV files, but MS Excel does not. But luckily theres a way around this. NOTE: This how-to has been based on Windows Vista, but will work on other Windows versions as well. ...