Text to Hyperlink

I have a spreadsheet with 3 collumns:

A = Network Share
B = Software directory name (Adobe Acrobat, Office 2010, etc)
C = "=HYPERLINK(A1&B1)"

I copied the entire sheet and pasted as just "value" so that I can delete column A.
I now want to have column A = Software directory and B = clickable link to take you to the network location

The problem I have is that column B shows all the correct network paths and blue like it is a clickable link, but clicking does nothing.
If I edit each one and just type a "\" at the end, or even just erase the last letter and type it again, it makes it a link.
The problem here is that my sheet has about 2000+ entries and it would take me forever to edit them all one at a time.

Is there a way I can tell excel to make whatever is in column B a hyperlink? I have included a small sample of the sheet I have.

Originally Posted by Cheeky Charlie

=hyperlink(B1) in C1 copied down will work.

Don't copy/paste with values if you want to retain hyperlinks.

Well, your answer puts me back the the original file with an extra column. If I start over from the start, how can I just delete column A and keep the column C data as hyperlinks? I don't want to just hide column A, and I want to see the actual text (up above) when I highlight something on column C, not just "=HYPERLINK(A1&B1)".

Originally Posted by Cheeky Charlie

=hyperlink(B1) in C1 copied down will work.

Don't copy/paste with values if you want to retain hyperlinks.

Well, your answer puts me back the the original file with an extra column. If I start over from the start, how can I just delete column A and keep the column C data as hyperlinks? I don't want to just hide column A, and I want to see the actual text (up above) when I highlight something on column C, not just "=HYPERLINK(A1&B1)".