before you delete the column with the original data in it, copy the column with the formula in it it, and paste values to itself. you canthen delete the original data