How to Remove Excel Formula While Keeping Cell Value

by

Often times when using formula's in Excel, you want to keep just the text values that a formula outputs while deleting the actual formula from the cells.

To keep a value in a cell while removing the formula that produced the value try the following:

  1. Type the formula =A1+B1 in cell C1.
  2. Copy C1 and keep it selected.
  3. Right-click on the selected cell C1 and choose Paste Special.
  4. In the Paste Special pop-up box, choose the radio button within the Paste section that says 'Values' and click OK.

In this example, we copied and pasted the values only (not the formula) right over the top of itself.  This is a quick and easy way to remove a formula from a cell without removing the final result of a formula. 

 

 


0
0

Add your comment

by Anonymous - Already have an account? Login now!
Your Name:  

Comment:  
Enter the text you see in the image below
What do you see?
Can't read the image? View a new one.
Your comment will appear after being approved.

Related Posts


This tutorial will teach you how to use the SUM function in Microsoft Excel to add column values together in order to calculate a total amount.  more »

Learn how to add two or more cells together in Microsoft Excel.  more »

Excel makes it easy to capitalize the first letter of every word in a cell. To capitalize each word you simply need to use the formula =PROPER(). For instance, if you have data in the cell A1, then you would want to enter the following formula in cell B1:...  more »

The following is a step-by-step example of how you can easily import delimited text files into Microsoft Excel. You can use the Excel Text Import Wizard to quickly import files delimited by Tab, Semicolon, Comma (also known as Comma Separated Value (CSV) file format), Space or Other (you choose), or divided by fixed width columns.  more »