View Single Post
 
Old 01-10-2017, 08:31 PM
xor xor is offline Windows 10 Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,097
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default

Let's say you your data in A1:A100 and the formulas in B1:B100 then do the following:

Select B1, press F2 and put a ' in front of the equal sign and press Enter. Now take a copy of B1 and paste it to for example G1 (to keep a copy of the original formula). You can, if you prefer, put a ' also i H1 to avoid the text spill over to the right of G1.
Now select B1:B100, take a copy and paste it as values to A1:A100. Select B1:B100 and press Delete.
Reply With Quote