Have you ever had a scenario where you write a formula and just want to show the value output only and get rid of the formula?

Here is an example of a formula:


Well I do not need the formula, bit I do want the last names only….hard copied!

Fortunately, I have discovered two ways that you can achieve this…



STEP 1: Select the area that contains the formulas.

Click CTRL+C

On the column that you want to place the values on, right-click and select Paste Values: 

You can see that the actual values are now stored in that column!


STEP 2: Here’s an alternative way.  Select the area that contains the formulas.

Right-click and hold on the right border.

Drag the border, whilst holding down the right-click on your mouse, to the area you want the values to be placed in.

Select Copy Here as Values Only.

You now have the actual values hardcoded!



If you like this Excel tip, please share itEmail this to someone


Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Share on Google+

Related Posts

DATEDIF function: Introduction The DATEDIF function is a mystery function within Excel.  When you write it out in a workbook it doesn't give you any hints like other functions would and if you look it up in the function list you would not find it! Creepy...The DATEDIF function stands for "date difference" ...
Cleaning Data with Excel’s TRIM Formula What does it do?Removes unneeded spaces in your text, except single spaces in between wordsFormula breakdown:=TRIM(text)What it means:=TRIM(text that you want extra spaces to be removed)In the quest for cleaner data, one of the common scenarios is remo...
Two Way Lookup Using The SUM Intersect Function There are various lookup functions that bring back values from a range of data like the VLOOKUP, INDEX, INDEX-MATCH and OFFSET functions, just to name a few.There is another lookup formula that you can use that will return the intersection of two Named Ranges!This is done...
Concatenate With A Line Break Excel's CONCATENATE functions joins two or more text strings into one string.  The item can be a text value, number, or cell reference.If you add a double quotation with a space in between " " then this will add a space between the texts selected on either side.You ca...