Organize and Refine the Extracted Data

Extract Data Using the Data Extraction Wizard

Organize and Refine the Extracted Data

 

Share Data Between Drawings and Applications > Extract Data from Drawings and Spreadsheets > Extract Data Using the Data Extraction Wizard > 

Organize and Refine the Extracted Data

Expand All Expand all collapsed sections. Collapse All Collapse all expanded sections.

Concept

Procedure

Quick Reference

To insert a formula column in the extracted data

1. Click Insert tab Linking & Extraction panel Extract Data.At the Command prompt, enter dataextraction
2. In the Data Extraction wizard on the Refine Data page, right-click a column label. Click Insert Formula Column.
3. In the Insert Formula Column dialog box, in the Column Name field, enter a name for the formula column.
4. In the Columns list, double-click a column name that contains numerical data. The column name displays in the Formula field.
5. Choose an operator button [ + - * / ]. The operator displays in the Formula field.
6. Add another column from the Column Name list, or enter a numerical value.
7. Click Validate.
8. Click OK.

 Toolbar: Modify II 

 Command entry: DATAEXTRACTION