If you have data in delimited text files from other programs that you need to get into an Excel workbook, you can use the import wizard to import delimited text files and convert them into usable ...

How to Create Pipe Delimited Files in Excel 2010. Microsoft Excel allows you to export spreadsheet data to a number of common formats for use with other applications. If you need to export data to ...

Notes: There is no option for changing the default Text to Columns delimiter in Excel, but you can achieve the same effect by setting the desired delimiters in a workbook and saving it as a template ...

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

Microsoft Excel’s new text functions make working with strings a breeze. Find out how to use TEXTAFTER() and TEXTBEFORE() in this tutorial.

cut and awk both do a great job of slicing and dicing tab-delimited data. Just make sure your data uses unix-style newlines (/n). If it uses windows style (/r/n), use dos2unix to convert first.