Creating Hyperlinks from multiple cells

[josephj]

I would like to create hyperlinks from 2 different cells with display text that says "Link" or the text from one cell.

Column A = a bill number formatted as 000#
Column B = standard url that forms a link when the correct "000#" in column a is added after the "hf" at the end of w.house.leg.state.mn.us/bills/Information/BillNumber?FileNumber=hf
Column C = is where i would like the hyperlink combined from A+B, preferably the hyperlink text displayed would say link or the Column A number (000#).

So far I've been able to combine the two using this formula: =B1&""&TEXT(A1,"0000"), but this only gets the correct link created. It does not create a hyperlink I can click on. Again I would also prefer that it display text instead of the link.

I've seen some possible MACRO solutions to almost similar problems but I am not finding one that works. It could be because I am very green when it comes to Macros and am not doing it correctly. Attached spreadsheet shows exactly what I am trying to do.

[AlphaFrog]

Try something like this...

Please Login or Register  to view this content.

The HYPERLINK function