Extract the TLD from a Domain in a Spreadsheet
Time to activate this blog again, no? For our domain name sales reports over at DNN I needed a spreadsheet function that separates the TLD from a domain name. I’m using OpenOffice and am planning on switching to LibreOffice, but I think this should work in Excel as well.
So if the cell that contains the domain name is “A1″, this is my formula:
=RIGHT(A1;(LEN(A1)-SEARCH(“\.”;A1)))
The search statement determines the location of the first Dot counting from the left. This number is then deducted from the total length of the text in A1 and then separated from the rest of the string by using the “RIGHT” function.