Extract URLs from Hypertext in Excel

In this post, I will explain the process to extract hyperlinks from a text/hyperlinked text using VBA/macros. 

Video: Click here to Watch Video.

Follow the below steps:

  1. Open the Excel file and paste the hyperlinked text in the column first.
  2. Open view code window by holding alt+F11.
  3. Paste the below code.
  4. Run the macro by using the "execute button" or by pressing F5.
  5. In column B you will get the desired result.
Code:

Sub ExtractHL()
    Dim HL As Hyperlink
    For Each HL In ActiveSheet.Hyperlinks
        HL.Range.Offset(0, 1).Value = HL.Address
    Next
End Sub

 Thank you for reading the post!

Comments

Post a Comment

Popular posts from this blog

Power Apps June 2023 Updates (Canvas App Focused)

Power Apps June 2023 Updates Power Apps June 2023 Updates Enhanced Component Properties Enhanced component properties are a new feature for Microsoft Power Apps that provide clearer and simpler concepts for properties. They are now divided into four types: Data properties: Simple properties that provide input or output data. Function properties: Properties that can accept arguments and return a value, but do not support data flow yet. Events and Actions: Behavior properties that can change the state of the app, such as updating a variable or manipulating a data source. The feature aims to make properties more intuitive and flexible, and to support more scenarios and behaviors. The team has updated the experimental feature and added support for SetFocus() and Select() in the existing. Read more: Enhanced Component Properties Blog Introducing an Easier Than Ever Experience to Import Data from Excel The document announces
Read more

Effortlessly Import JSON Data into SharePoint with Power Automate Flow: A Step-by-Step Guide

Image
Effortlessly Import JSON Data into SharePoint with Power Automate Flow: A Step-by-Step Guide Importing data into SharePoint can be a time-consuming and complex task, but with Power Automate Flow, you can easily import JSON data into SharePoint with just a few clicks. In this post, we'll show you how to do just that with a step-by-step guide. Why Import JSON Data into SharePoint with Power Automate Flow? JSON (JavaScript Object Notation) is a lightweight data-interchange format that is easy for humans to read and write and easy for machines to parse and generate. It's a popular format for exchanging data between different systems and applications, and it's often used to store and transfer data over the web. By importing JSON data into SharePoint, you can make this data easily accessible and manageable in SharePoint. How to Effortlessly Import JSON Data into SharePoint with Power Automate Flow Here's a step-by-step guide to effortlessly importing JSON data into SharePoin
Read more

Unleash the Power of Power Apps: Retrieve Over 2000 Records from a SharePoint List Effortlessly Without Delegates

Image
Unleash the Power of Power Apps: Retrieve Over 2000 Records from a SharePoint List Effortlessly Without Delegates Working with large data sets can be a challenge, especially when it comes to retrieving data from a SharePoint list using Power Apps. The traditional method of retrieving data from a SharePoint list is by using delegates, which can be time-consuming and may even limit the amount of data you can retrieve. But what if we told you there's a better way to do it? In this tutorial, we'll show you how to retrieve over 2000 records from a SharePoint list using Power Apps without delegates. That's right, you can easily retrieve a large number of records in just a few simple steps. To get started, watch our step-by-step video guide on how to do it: https://youtu.be/R2wHybiwDNQ In this video, we'll show you how to create a Power App that retrieves data from a SharePoint list and displays it in a gallery. We'll also show you how to apply a filter to the data so that
Read more