Remove all characters before domain & subdirectory in URL

[RD_MG]

Similar to this thread: http://www.mrexcel.com/forum/excel-...-url-except-root-domain-domain-extension.html

I'm looking for a formula within Excel to remove all characters before the domain. Below are a couple of examples as the list will be ever-growing, and will also be paired up with another column to match specific strings of data.

Example URL String	Result
https://www.example.com	example.com
https://example.uk/	example.uk/
http://www.example.com/sub123	example.com/sub123
http://example.com/sub123/example/	example.com/sub123/example/

<tbody>
</tbody>

Ultimately I'm looking to address the different variations of https & http, as well as www and non-www. Plus any variation of country codes, with or without an ending forward slash that doesn't get removed if it is present.

Any help would be greatly appreciated!

 

[Eric W]

Welcome to the forum.

If I read this correctly, your issue is a bit simpler than the other thread. This might work:

	A	B
1	Example URL String	Result
2	https://www.example.com	example.com
3	https://example.uk/	example.uk/
4	http://www.example.com/sub123	example.com/sub123
5	http://example.com/sub123/example/	example.com/sub123/example/

<colgroup><col style="width: 25pxpx"><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet1​

Worksheet Formulas Cell Formula B2 =SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A2,"https://",""),"http://",""),"www.","") <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

 

[Scott Huish]

Also:
=SUBSTITUTE(MID(A2,FIND("//",A2&"//")+2,2083),"www.","")

I went with 2083 because after a little research, that seems to be the longest URL supported by any browser.

 

[RD_MG]

Welcome to the forum.

If I read this correctly, your issue is a bit simpler than the other thread. This might work:

	A	B
1	Example URL String	Result
2	https://www.example.com	example.com
3	https://example.uk/	example.uk/
4	http://www.example.com/sub123	example.com/sub123
5	http://example.com/sub123/example/	example.com/sub123/example/

<tbody>
</tbody>

Sheet1​

Worksheet Formulas Cell Formula B2 =SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A2,"https://",""),"http://",""),"www.","") <tbody> </tbody>

<tbody>
</tbody>

Thanks for the warm welcome and I was certainly overthinking things! This worked and I truly appreciate it!

Also:
=SUBSTITUTE(MID(A2,FIND("//",A2&"//")+2,2083),"www.","")

I went with 2083 because after a little research, that seems to be the longest URL supported by any browser.

This worked as well, thanks!