To Insert a Formula Column in the Extracted Data

  1. Click Insert tab Linking & Extraction panel Extract Data. Find
  2. On the Refine Data page, right-click a column label and choose 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 to add it to the Formula.
  5. Click an operator button [ + - * / ]. The operator displays in the Formula field.
  6. Add another column from the Column Name list, or enter a numerical value and click Validate.
  7. Click OK to add the column to the table.