Turn Plain Text URLs into Hyperlink – Google Spreadsheet Tricks
If you have a spreadsheet with the huge number of rows with URLs which are displaying as text, and these are not clickable in your Google Spreadsheet, you can try the following method to make them as hyperlinked.