Parsing a URL

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.

Try this

Please Login or Register  to view this content.

Hope this helps

Thanks for the reply. Wow, that was the biggest nested statement I've ever seen! I tried it and it just evaluated to blank. There wasn't any error though, so I'm not sure why it doesn't work.

Doubtless there is a more elegant solution, but it seems to work for me.
See the demo workbook attached

Add a URL to Column A, then drag/fill the formula in Column B down,

Hope this helps.

Thanks the formula in the excel sheet worked great!