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

Here I have given an example of a formula:

I have no need of this formula, but I do require the last names only in my hard copies.

Fortunately, there are two ways that will help you to convert formulas into values.

## Convert Formula to Value By Simple Copy & Paste;

Firstly, you will need to select all the area that contains those formulas.

Then to copy them, Click **CTRL+C**

You will automatically get that actual values stored in that same column.

Using the basic formulas in Excel greatly speeds up the work with calculations. We need no longer to count each individual line to get the correct result.