Point in the right direction for modifying website addresses down

[mawilson12]

Can someone point me in the right direction?
I have a list of websites.
www.server.website1.com
www.website1.com
www.server2.website2.inf
website.info


What I want do do is put the last two sections (example: website1.com) into a separate column so that I can start counting things that are the same.
I assume I have to count the number of "dots" (periods" and start an extract from the second one forward, but I am unsure how to put it all together in a comprehensive formula or VB script.

 

[John_w]

Try this UDF.

Public Function Last2(address As String) As String
    Dim parts As Variant
    parts = Split(address, ".")
    Last2 = parts(UBound(parts) - 1) & "." & parts(UBound(parts))
End Function

Use as a cell formula: =Last2(A1)

 

[njimack]

Excel Workbook
	A	B
1	www.server.website1.com	website1.com
2	www.website1.com	website1.com
3	www.server2.website2.inf	website2.inf
4	website.info	website.info
Sheet3