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:

Convert Formulas to Values in Excel

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

Convert Formulas to Values in Excel
After that, you need to paste the formulas on the column that you want to place the values on. So, do the right-click and select Paste Values: 

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

Convert Formulas to Values in Excel