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…

DOWNLOAD EXCEL WORKBOOK

 

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!

HELPFUL RESOURCE:

How to Combine VLOOKUP and IFERROR to Replace the #N/A Error in Excel

 

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

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

Share on Google+

Google+

Related Posts

Calculate Total Sales With An Array Formula An Array Formula performs an Excel operation (math, comparative, join or function argument) on an array or range of data.  This could be a range of cells, a worksheet reference or a defined name. One of the most popular uses of an array formula is to calculate Total Sales. ...
Vlookup in Multiple Excel Sheets What does it do? Searches for a value in the first column of a table array and returns a value in the same row from another sheet´s column (to the right) in the table array. Formula breakdown: =VLOOKUP(lookup_value, table_array, col_index_num, ) What it means: =VLO...
VLOOKUP Multiple Columns What does it do? Searches for a value in the first column of a table array and returns the sum of values in the same row from other columns (to the right) in the table array. Formula breakdown: {=SUM(VLOOKUP(lookup_value, table_array, {col_index_num1,col_index_num2}, ))}...
Free Excel Formulas & Functions Webinar Train... In this popular Free Excel Formulas & Functions Webinar Training which goes for 60 minutes you will learn the MUST KNOW Excel Formulas to ADVANCE your Excel skills! You will learn the following Excel Formulas & Functions: IF, SUMIF, VLOOKUP, INDEX/MATCH + MORE...! P...