# How to Extract Link from a Column?

**URL:** <https://connect.superhuman.com/t/how-to-extract-link-from-a-column/1899>\
**Category:** Ask the Community\
**Created:** [August 16, 2018, 9:43am UTC](https://connect.superhuman.com/t/how-to-extract-link-from-a-column/1899 "2018-08-16T09:43:42Z")\
**Posts on this page:** 1\
**Showing post:** 5

<div class="post-metadata">

**Author:** ![Ben\_Lee](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/ben_lee/32/49867_2.png) [@Ben\_Lee](https://connect.superhuman.com/u/Ben_Lee)\
**Post date:** [August 17, 2018, 2:53pm UTC](https://connect.superhuman.com/t/how-to-extract-link-from-a-column/1899/5 "2018-08-17T14:53:58Z")

</div>

\*_The following solution no longer works at the moment. Updates to [link display options](https://connect.superhuman.com/t/launched-enhancements-to-creating-editing-links/7743) where made, but they also breaks the functioning of this solution._

Here’s the same solution that works in just one extra column:

```auto
Link.Embed().ToText().Hyperlink(Right(Link.Embed().ToText(),Link.Embed().ToText().Length() - 39))

```

 ![link-to-titled-link-one-column](https://global.discourse-cdn.com/coda1/original/2X/b/b43c7f8ec572e875d7e0b1c8beb7e37e951fdad7.png)

This removes the “If” statement as well, so it looks a little cleaner if you have a link in every row.

---

_[View the full topic](https://connect.superhuman.com/t/how-to-extract-link-from-a-column/1899)._
