Extract text

Use Text to capture a specific piece of text from a file and place it directly in your worksheet.

  1. On the ribbon, select Text.

  2. In your worksheet, select the cell where you want to insert the extracted data.

  3. On the sidebar, draw a box around the text to extract.

  4. The extracted text appears in the cell.