Delete formula without deleting the result ( yield )

  • Thread starter Thread starter chooriang
  • Start date Start date
C

chooriang

Hi,I am Cho
I have about 1800 microsoft excel cell that contain the various result of
formula.Now I want to delete the formula but don't wanna delete the
result.Is it possible.
I also don't want to re typed them again

Any suggestion,It would be appreciated

Regards,

Cho
 
Select your area
Edit>Copy
Edit>Paste Special - check Values

Et voilà!
 
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

Export data from excell to access 2
New record overwritten on old column 5
how do i delete using COUNTIF for specific values? 2
delete formulas but retain answer 4
MS Excel help 6
Excel viewer does not display formula values 1
Conditional formatting based on formula cell 6
preventing formulas from deletion 3

Back
Top