• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 11. Using Excel's Built-In Funct... > Converting Formula Results to Values

Converting Formula Results to Values

If you write a formula, such as a CONCATENATE formula, then delete the referenced cells that you no longer need on the worksheet, the formulas won't work any more. You can, however, convert the formula results to values so that you can delete the unnecessary source cells without changing the results that the formulas produced.

Another situation which calls for conversion is breaking a workbook or worksheet link. If you've written formulas that link workbooks or worksheets and you want to break the links because you don't need the links and don't want to be bothered with the update messages, you can break those links by selecting the cells with the linking formulas and converting them to values.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint