Open an application that contains the text you'd like to parse, then copy the text by highlighting it and pressing "Ctrl-C." Launch Excel and create a new workbook. Click the workbook's "A1" cell ...

1. Insert a text box. Insert a text box in Excel from the Insert tab by selecting Text, Text Box, and then use your mouse to drag to a region on your worksheet. 2. Insert a formula in the text box.