How do I delete formulas but save numbers?

  • Thread starter Thread starter Guest
  • Start date Start date
Hi Dino,

Select the range, copy and paste special values

HTH
Regards from Brazil
Marcelo

"Dino" escreveu:
 
Choose the range of formulas and copy it. Then, select the same or other
range and choose Paste Special, Values.

Hope it helps
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How Do I Avoid #REF! In Formulas? 4
How to subtract a number from a Mergefield? 0
How do I transfer formulas but not the information? 1
Remove the formulae, but keep the data 3
IF AND Nested Functions - Formula Not Working 0
how do I delete data in a cell without deleting formula? 1
putting number against certain words formula 0
SUMPRODUCT formula I think w/ wild card & number vs number as text 8

Back
Top