How to remove hyperlinks from multiple cells in Excel?

It is a nightmare that Excel is trying to open a new web page for all the sells that you kust need to see or copy as a plain text!
I found a very simple solution for that and want to share it with you:

What you need to do is simple multiply the cells with 1 that you want to remove the hyperlinks:)
Select an empty cell and type 1, then select all cells that you need to remove hyperlinks, via pressing shift key, then right click and select paste special. There click the option multiply and it is done!
Nice, jaa??