To Insert a Formula Column in the Extracted Data
Click
Insert tab
Linking & Extraction panel
Extract Data
.
Find
On the Refine Data page, right-click a column label and choose Insert Formula Column.
In the Insert Formula Column dialog box, in the Column Name field, enter a name for the formula column.
In the Columns list, double-click a column name to add it to the Formula.
Click an operator button [ + - * / ]. The operator displays in the Formula field.
Add another column from the Column Name list, or enter a numerical value and click Validate.
Click OK to add the column to the table.
Related Concepts
Organize and Refine the Extracted Data
Related Tasks
To Edit a Formula in Extracted Data
Related Reference
Commands for Data Extraction