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.

To capitalize the first letter of a text string in Excel, you can use a formula that combines multiple functions. We show you how to do it.

Have you played with the "Text to Columns" function on the Data menu/tab yet? It's similar but not quite identical to the File Open text importer.