Scrapebox exports to Excel..Clickable links

Is there any efficient way to make all the links in a Scrapebox export to Excel clickable.

So far I have been selecting the cell, pushing the space bar, and then moving on to the next cell.

That is fine for a couple of links. But, I have a Scrapebox number of links. I need a way to make over a thousand PR links clickable.

I use Excel 2007.

Thank you for your consideration.

Input the following code into a macro. Select the cells you want to convert to hyperlinks and run the macro.

Or from scrapebox export list as .html. Then in excel open the .html file. It leave the table but the links are clickable.

Thanks for the help. As soon as I figure out how to unhide a sheet I think this will work. Saving as HTML works too, but I need to edit it.
Either way, you both answered my question and I thank you.

I am amazed at the answers I get on this forum. I ask a question about making links clickable in an Excel SS in a blackhat marketing forum and I have two workable answers in less than an hour or so. God only knows how much money Microsoft has, but they can't even pay people to do the job this well.
Awesome.