Hi there,
This is my first post, so don't flame me for breaking any rules. I can't figure out how to parse a URL in Excel. I have columns with URLs, some with www and some without. Example:
http://www.example.com/index.php?xyz
http://example2.com/category/xyz/post.aspx?index=0
I'm trying to extract just the domain name. So for the above examples I would like:
example.com
example2.com
I tried the LEFT and MID functions but they only allow me to choose the number of characters and not a delimiter like /.
I'm pretty sure you have to use VBA, but I'm pretty green when it comes to programming. Any help would be appreciated. Thanks in advance.
Bookmarks