Combine Text Fields and External URL Links Using the HYPERLINK Formula in Salesforce

For example, you have a URL field called 'URLfield__c' that has a value of 'www.salesforce.com' and a text field that has a field name of 'Textfield__c' with a value of 'Test'.

This is the sample formula that you can create:

         HYPERLINK("https://"+ URLfield__c, Textfield__c,'_blank')

In this formula, URLfield__c is the API name of your URL field and Textfield__c is the API name of your text field. The '_blank' parameter opens the link in a new browser tab. Replace these field names with the actual API names of your fields.

The expected results on the formula field:
Test (with a clickable link that opens up a new tab from your current browser to take you to the link that you have specified in the URL field)