1. Double click on cell.
2. Select Text, where you want to add link.
3. Add link 
1. Use keyboard shortcut : Ctrl + K (Windows) OR Cmd + K (Mac).
2. Choose "Insert" > "Insert Link" from the menu.
3. Click on the "Insert Link" button from the toolbar.

How to Add Multiple Hyperlinks to a Single Cell with App Script

•  newRichTextValue()
•  RichTextValueBuilder

var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Sheet1");
var cellValue = SpreadsheetApp.newRichTextValue()
  .setText("url1 and url2")
  .setLinkUrl(0, 4, "http://www.google.com/")
  .setLinkUrl(9, 13, "http://www.youtube.com/")
  .build();
sheet.getRange("A1").setRichTextValue(cellValue);

How to Get the Hyperlinks of Cell from Google Sheets with App Script

var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Sheet1");
var url = sheet.getRange()("A2").getRichTextValue().getLinkUrl();

• Set or Get Multiple hyperlinks in Google Sheet cells.
• Everything a Google Apps Script Developer wanted to know about reading hyperlinks in Google Sheets … but was afraid to ask

1. Copy instagram video or photo’s link from the app or website. (Tap 3-dots above the post and then "Copy Link" ) 
2. Get HTML source code of Instagram link through Javascript.
3. If you analyze the HTML source code, you will find that the actual link to the Instagram photo or video is stored in the meta tag with "og: video" or "og: image".
   
4. And finally extract this link via JavaScript and give it to the user.

<!DOCTYPE html>
<html>
<body>  
  <script>
     var xmlhttp = new XMLHttpRequest();
     var url = "https://www.instagram.com/p/B-Rl4iKp4HK/";
     xmlhttp.onreadystatechange = function() {
         if (this.readyState == 4 && this.status == 200) {
             var htmlSource = this.responseText;
             document.getElementById("id01").value = htmlSource;
         }
     };
     xmlhttp.open("GET", url, true);
     xmlhttp.send();
  </script>
  <textarea id='id01' />
</body>
</html>