convert values in calculated column to values only (get rid of expression)

I would like to convert a calculated column to values only -- in other words, get rid of expression with only calculated values remaining. I do this in Excel by "copy" the column and then "paste special - values" back onto itself in the same column (or a new column). The result is values only and no formulas.

The reason I need this is because I want to delte the source column that the expression is based on, plus reduce the CPU load (20M rows).

Thanks!

(1) Answer

Login