Excel’s Text functions are a major time saver if your job entails managing massive data, especially data that’s imported from other sources. Fortunately, all ASCII data is easily imported, but ...

Launch Excel and create a new workbook. Click the workbook's "A1" cell and press "Ctrl-V" to paste your text into that cell. Click the "Data" button in the menu bar, then then click "Text to Columns." ...

5. In Step 3, click the first column and, from the Column Data Format panel, click the Text button. Click the next column, and select the Text button again, and so forth to the end, then click Finish.

Excel will provide an option for Text2, Text3, and so on if you have additional text strings and/or ranges of cells to include. Click OK . The ­ Formula result (circled in red in the screenshot) will ...