Create a list of links from cells of Excel table

Another small note on working with tables – if we have a table with a list of links and link anchors from which we need to quickly get a complete simple link like <a href=”link”>text</a>, we can use the following formula:

="<a href="""&A1&""">"&B1&"</a>"