Paste as values, the Paste Special window

Some­times, when we have for­mu­la results, we want to have only the text, i.e. the answer (Fig. 1). 

We can copy the results, then right click a tar­get cell and choose the Paste Val­ues option from the pop-up menu (Fig. 2). 

And, we have just text not for­mu­la (Fig. 3).

There is one more solu­tion. When we copy our for­mu­la, we click on a tar­get cell and press Alt + Ctrl + V com­bi­na­tion to show the Paste Spe­cial win­dow (Fig. 4). In the Paste area, we click Val­ues, in the Oper­a­tion area, we choose None, then we press OK. 

Now, we have the results only once. We don’t need the extra col­umn, so we must delete it (Fig. 5) 

https://www.youtube.com/shorts/3UD7n8Jtu3I