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.