Adding hyperlinks using URLs from adjacent column

[comicb]

Hello,

In my Google spreadsheet:

Column A contains 5,000 cells with with text
Column B contains 5,000 cells with URLs

I want to create a hyperlink for the text in Column A using the URLs in Column B.

Please point me in the right direction if you can.

Thanks!

[bebo021999]

Basically, try in A1:
=HYPERLINK(B1,"Text 1")

Assum there are thousand of text in column A already, using other column C to store it:
Copy column A to C (paste special/value)
Then in A1:
=HYPERLINK(B1,C1)

Hide column C if you want

[comicb]

Awesome - thank you!