Forum Discussion
WillHaydock
Feb 05, 2024Copper Contributor
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.
- Harun24HRBronze ContributorPost few sample data and attach a sample file to your post.
- GeorgieAnneIron ContributorHello 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.