hi, i just need a way to select the entire contents of a column with formulas and that has non-contiguous data and then paste the values back in. in the example below col B goes down to a variable amount of rows and each cell in that column has formulas in it. i want to be able to go to end of the column and then paste value special the contents so the data is there but the formulas aren't. thx.

B
1
2
56

78

32

3