How to use hyperlink in Excel formula

[shishand]

I'm trying to manage a database and make it easier for use. Basically, the database consists of several rows, like "license#", "name of the company"..ect, i just need help with one formula, in the row B, which is the license number row, it goes something like this:
LIC NO
921769
668812
629948

i want to make it so that everything number in that list would be a hyperlink, in this format:
"https://x.com/b/e/a.aspx?LicNum=921769"
basically number in that row, which clicked, would direct me to the internet with this link "https://x.com/b/e/a.aspx?LicNum=XXXXX" and where XXXXX stands would be the number that i clicked on.

is such thing possible?

[outofthehat]

You can use the HYPERLINK function. For example, if licence number is in A2, this will generate you a hyperlink, e.g. in the cell next to it:
=HYPERLINK("https://x.com/b/e/a.aspx?LicNum="&A2,"Click to see "&A2)
Then copy it down next to your licence numbers