Use Paste Special-->Values. I would do in an adjacent column and then delete the other columns.