How to make links work in Google Sheets?

Question

Google Sheets

There is a table in which the column contains a thousand URLs. All of them are non-clickable. If you select any of them and press F2, and then Enter, then the link becomes working. How to do this without processing each individual cell?

Tried to copy and paste to other sheets and tables - nothing changes.

Answer 1

find http and replace with http in the range of cells where the links are indicated
so far this is the fastest option in my opinion