Forum Discussion

WillHaydock's avatar
WillHaydock
Copper Contributor
Feb 05, 2024

Extracting URLs from content that's been dumped into Excel

I have several large xlsx files (think 20-50k rows) that include long pieces of written content containing URLs. How do I extract all URLs into their own unique cells? They can also remain in the original cell, but I need them in separate cells to support further analysis.

  • Harun24HR's avatar
    Harun24HR
    Bronze Contributor
    Post few sample data and attach a sample file to your post.
  • GeorgieAnne's avatar
    GeorgieAnne
    Iron Contributor
    Hello WillHaydock

    You can look for a specifc string in the source sting for example a URL usulay starts with https:// or www.

    So look into these functions:
    MID()
    FIND()
    SEARCH()
    LEFT()
    RIGHT()
    and also if you have an updated version of Excel you can look at SPLIT().

    You can also look into Text To Columns on the Data tab but that might be harder.

    Let us know if you need more help.

    G.

Resources