Select the delimited text and copy it to the clipboard. Launch Excel and create a new workbook. Click the first cell in column A and click the "Paste" button in the ribbon.

This is the demonstration file to accompany the article, How to quickly extract delimited data using Microsoft Excel Power Query by Susan Harkins. Skip to content TechRepublic ...

Excel saves the file in pipe-delimited format in the folder you selected. Advertisement. Article continues below this ad. More For You. How to Use a Hiragana Keyboard.