Pasting Text to hyperlink

Hey Guys
I have a spreadsheet that has 700 lines of web links but they are formatted as text.
Is there any way I can just copy and paste them to hyperlinks that will enable me to click on one and then it takes me to that web address?

Thanks in advance
cd

Hi there

Thanks for responding

Sort of works but have an issue

If I select the range of 700 lines and run the code...it converts them all to hyperlinks but no matter which line I then click it takes me to the hyperlink of the first line only.

Can you amend it slightly please?

Thanks again
cd