Compile Error Highlights beginning of url text in Formula

First of all let me say the moderator bot or whatever would not allow me to post this question because it contained a link. I had to get creative and replace 5 certain letters with haich tee tee pee ess in the "code" below

I am trying to create a formula that is copyable through a range of cells that will create a hyperlink to a webpage of action items in each cell of column A. The url of each hyperlink is common until the last 5 characters, which is the action item number. The action item number itself is contained in column L, so I wanted to concatenate the partial url and L information together.

After typing in the info, vba brings up the Compile Error: Expected End of Statement while highlighting the "haich tee tee pee ess" text in the formula. I tried the formula on its own in a single cell in the worksheet and it works fine.
Example is below, but url info has been changed due to proprietary info.

Please Login or Register  to view this content.

The expected result after macro is run: if L1 contains the number 34262, A1 contains a hyperlink to action item 34262 on the website, same for each A cell and its corresponding L cell.

Any insight appreciated