Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community

Extracting URLs from content that's been dumped into Excel

Copper Contributor

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.

2 Replies
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.
Post few sample data and attach a sample file to your post.