How do I delete the formula but keep the results

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I delete the formula in the formula bar and keep the results from that
formula in a column. I read how to do this last week on this forum but now
I can't find the answer!!!!!!!!!.
 
Or for a range: select the range and use Copy,
then, without deselecting the range, use Edit|Paste Special and specify
Values
 

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

Excel VBA 1
COUNTIFS ? 1
Concantenate which keeps bold of some parts. 5
Help needed 0
Excel Help to copy information from one row at a time to another sheet 1
VBA code for Sum and diff 1
formula errors 2
Counting Results of Formulas 1

Back
Top