Extract Domain from URL

Please Login or Register  to view this content.

assuming you want the results outlined in your OP (ie remove string prior to period preceding domain qualifier)

Please Login or Register  to view this content.

above is VBA - if you want formula equivalent let us know.

formula wise - with string in A1

Please Login or Register  to view this content.

In which case, assuming you can't use the entire string (per snb's original - eg b.static.ak.fbcdn.net rather than fbcdn.net) then things become more complicated.

The complexity stems from the fact that there is little discernible logic in establishing which parts of the full domain are relevant and which are not... you will I think require a list detailing all possible domain qualifiers (eg .com, .com.uk etc...)

If you want to pursue that post back with the list, some relevant examples and expected results.

Jerry, could you please upload your file here directly ?
(to attach a file click the Paperclip icon within the Reply Window - if not visible first click Go Advanced and proceed from there)

Per my earlier note - given the lack of consistency I think you will need to detail all various qualifiers that may exist.

I've put together a rough example using a formula based approach as I get the impression that's your preference.
(the calculation is split based on assumption of XL version prior to XL2007)

Note: it's important that the .domain.domain type qualifiers are listed below the .domain qualifiers (see Col E)

On a final final note - please be aware that your Location is an important factor when it comes to people helping you as there exist significant locale differences in Excel (delimiters, date handling etc)
For your own benefit I would suggest you modify the specified Location in your profile accordingly.

edit: should add that the ordering of the all the qualifiers is important and we assume that where they double up they do so in pre-determined format (ie .com.net rather than .net.com)
a UDF would be pref. in my opinion.

I am sure with more thought this could be streamlined, however, as a basic example - utilising the same named range listing as before (re: qualifiers)

Please Login or Register  to view this content.

called from a cell along the lines of:

Please Login or Register  to view this content.

at this point the ordering of the qualifiers becomes irrelevant - ie the above should prove more robust than the formula equivalent
(eg possibility of .net.com and .com.net is not an issue)