Save As HTML & Retain Links [About to Rage]

Trying to do a concatenate function inside the hyperlink function is screwing you up.

There's a simple fix:

Please Login or Register  to view this content.

Now when you save to HTM the links should work.

Perfect!
That worked great thank you very much.

I am now trying to get this to work in a .PDF file.
Seems to be giving me a bit of grief as it will only display a straight Hyperlink,
For example http://www.google.com

If I start trying to use my cell references in the formula, it doesn't recognise as a Hyperlink when opening.

assets2.xlsx