Hello. I have used special select to select all blanks in a column (non-adjacent). I then copied a formula into all of these cells. However, now I want to copy paste special values over all of these formulas and it won't allow me to do so. I have other formulas in the column but I don't want to copy paste special values over these; just the cells that were formerly blank. How can I do this?