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

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

Generic Design Powerapps, Sharepoint and flow

  1. Backend: SharePoint You will use SharePoint to store all the data required for the event management system. Create the following SharePoint lists for different entities: Event List : Stores event details (e.g., Event Name, Date, Location, Description, Organizer, Capacity, Registration Deadline). Columns: Title, EventDate, Location, Description, Organizer, Capacity, RegistrationDeadline, etc. Attendees List : Tracks attendees for each event. Columns: AttendeeName, Email, Event (Lookup to Event List), RegisteredDate, Status (Registered, Waitlisted), etc. Feedback List : Captures feedback from attendees post-event. Columns: Event (Lookup), Attendee (Lookup), Rating, Comments, etc. Notification Settings List : Manages notification triggers and timing for automated emails. Columns: NotificationType (e.g., Reminder, Registration Confirmation), TimeBeforeEvent (in hours/days), EmailTemplate, etc. 2. Front End: Power Apps The Power Apps application will serve as the main interface for...
Read more