Hello..
I'm trying to get a calculated column for a URL configured to work properly but I can't get it working correctly.

Here's the column setups:
Title Type
Department Name Text
Department URL URL
Departments Calculated Column

The Departments column, I have the following expression configured but it's not showing up as I'd like it to.  Expression: '<a href="' + [Department URL] + '  target="_blank">' + [Department Name] + '</a>'

How can I configure this so that the person entering the information into the form can select a page on the website and enter a name so that it looks and hyperlinks correctly.

Thanks.. -Jeff

For the Departments URL, I'm selecting the Fiscal page on the DNN website.  For the Department Name, I'm entering Fiscal Department.

This is how Firebug is reporting the link; obviously not what I'm looking for.
<a main.aspx"="" fiscal="" departments="" www.website.com="" http:="" href="<!--http://www.website.com/departments/fiscal/main.aspx--><a href=" target="_blank">http://www.website.com/departments/fiscal/main.aspx</a>