Toggle Help Topics Menu >

Extract Text

The Extract Text tool extracts all the text contains in shapes and outputs it to the worksheet.

Form Fields

  • Shape listing: Includes a listing of the text and a selection checkbox indicating whether to extract the text for each shape.
  • Sort by: Sorts the text listing alphabetically or by shape position (column then row, or row then column).
  • Output range: Indicates where on the worksheet the text will be extracted.
  • Link shape content to cells: If checked, any changes to the text in the worksheet will automatically update the text in the shape.