Saving Excel with Pipe Separator - Not Changing Windows List Separator
Posted on 2014-04-29
I need to import a file into Excel that is a pipe delimited file. I can open the file but when I go to save it, it must be a csv file which saves with commas, not pipes. It would not be a useful process to change the List Separator from comma to pipes within the advanced settings of the control panel in Windows. Is there a way to save from within Excel so we can change the comma to pipe?