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 ...

To ignore all numbers stored as text, you need to open the Data tab and select the Text to Columns option. Then, select the Delimited option from the Convert Text to Columns wizard.

Learn how to use Excel Power Query's extract and split column features to extract delimited strings into their components.

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.