The quickest way I've found is to use the Find and replace option under the Home tab.
First select the cells you want to copy over and use Find and replace to change the = to a '= the copy your cells and paste them in your new sheet and then use find and replace to change the '= back to =