A solution has already been accepted for this, but if you want a fixed value for the optional text (e.g., Click Here) and use the hyperlink field, you can use JSON list formatting with the following code:
{
"$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
"elmType": "a",
"txtContent": "\u200B Open Link",
"attributes": {
"iconName": "OpenInNewTab",
"class": "ms-fontColor-themeDark",
"href": "=@currentField",
"target": "_blank"
},
"style": {
"font-size": "12px",
"text-decoration": "none",
"font-weight": "normal",
"margin-left": "6px"
}
}
Just replace the value after txtContent with what you want listed. The above code also displays it with an icon. Just remove the iconName line from the code if you don't want to use it. You can choose a different icon from Office UI Fabric Icons
