Have Hyperlink Show up as image or text

I have a link to a google document on one of me sheets. After the link is entered…It shows up as the full link in the cell which is really long. Is there any way to have the link show up as text that says “Click Here” or some kind of image icon?


You may use the bbcode to achieve this.

This doesnt seem to work. What am I doing wrong?


Please change the field type of “Link to ATOS FILE” field to the free text field type.

Perfect! That worked. Thank you!

It would be nice if this was hard coded in as an option for a URL cell.