Excel create a GETURL function

  1. Open the workbook
  2. Enter into the VBA editor (Press Alt+F11)
  3. Insert a new module (Insert > Module)
  4. Copy and Paste the Excel user defined function below
  5. Exit out of VBA (Press Alt+Q) the function will be saved
  6. Use this syntax for this custom Excel function: =GETURL(cell)

By the way

  • VBA stands for Visual Basic for Applications