Try copying the entire region containing the data and without changing the selection hit paste special and then select values.

This will convert all formula to their current values so make sure that you do this on a copy to protect your original formulae.