Xcel csv file and pipe delimiter

%3CLINGO-SUB%20id%3D%22lingo-sub-1321186%22%20slang%3D%22en-US%22%3EXcel%20csv%20file%20and%20pipe%20delimiter%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1321186%22%20slang%3D%22en-US%22%3E%3CP%3EI%20operate%20on%20windows%2010%20(office%20365)%20-%20I%20have%20been%20asked%20to%20save%20an%20excel%20file%20as%20a%20csv%20file%20(with%20comma%20delimiter)%20then%20open%20in%20notepad%20-%20the%20comma%20should%20change%20to%20a%20pipe%20delimiter%20-%20how%20do%20we%20do%20this%20on%20windows10.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1321186%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Visitor

I operate on windows 10 (office 365) - I have been asked to save an excel file as a csv file (with comma delimiter) then open in notepad - the comma should change to a pipe delimiter - how do we do this on windows10.

 

 

0 Replies