Convert Formulas to Values

Data results output in Excel

Purpose

The Convert tool allows you to quickly convert formulas to values. This is especially effective for converting Seotools Dump() formulas because they sometimes recalculate when performing a "regular" paste as values. The red Dump() formula comments are also removed (see example GIF above).

Modes

  • Selection - Converts all formulas within the selected range. The range must be entirely outside pivot tables and tables or inside a table.
  • Active Sheet - Converts all formulas in the active sheet. No tables or pivot tables can exist on the sheet.

Related Functions

Get help with this function in the community →