How to get Hyperlink in excel?

Create a link to a web page
On a worksheet, select the cell where you want to create a link.
On the Insert tab, select Hyperlink. 
Under Display Text:, type the text that you want to use to represent the link.
Under URL:, type the complete Uniform Resource Locator (URL) of the webpage you want to link to.
Select OK.

Regards,

Rachel Gomez

To retain the hyperlink as a clickable link in the exported data, you can add a custom function to format the dynamic link as an HTML hyperlink in the exported data. You can do this by creating a custom function that takes the dynamic link as an input and returns a string that contains the dynamic link formatted as an HTML hyperlink.

Here's how you can create a custom function in Appian to format a dynamic link as an HTML hyperlink:

1. Create a new expression rule in your Appian application.

2. In the expression rule, define a custom function that takes the dynamic link as an input and returns the dynamic link formatted as an HTML hyperlink. Here's an example of what the function might look like:

   function formatLink(link) {
     return "" + link + "";
   }

3. In your summary interface, use the custom function to format the dynamic link as an HTML hyperlink. 

4. When you export the data from Appian, the dynamic link will now appear as a clickable HTML hyperlink in the exported data.

This should solve the issue of the dynamic link not appearing as a clickable link in the exported data.