Pinterest Pixel

How to Convert Formulas to Values

  Have you ever had a scenario where you write a formula and just want to show... read more

Download Excel Workbook
Bryan
Posted on

Overview

How to Convert Formulas to Values | MyExcelOnline

 

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:

How to Convert Formulas to Values

 

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…

How to Convert Formulas to Values | MyExcelOnline

Download excel workbookConvert-Formulas-into-Values.xlsx

 

STEP 1: Select the area that contains the formulas.

Click CTRL+C

How to Convert Formulas to Values

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

How to Convert Formulas to Values

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

How to Convert Formulas to Values

 

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.

See also  Advanced SUMPRODUCT Function: Count

How to Convert Formulas to Values

You now have the actual values hardcoded!

How to Convert Formulas to Values

 

 

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

How to Convert Formulas to Values | MyExcelOnline
How to Convert Formulas to Values | MyExcelOnline
Bryan

Bryan is a best-selling book author of the 101 Excel Series paperback books.

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!