Column division, filter Formula

JohnGreenwood 

You can use the following formula to separate the domains and subdomains into two different columns in Excel:

1. In the first cell of the “Domain” column (let’s say it’s B2), enter the following formula: =IF(ISERROR(FIND(".",A2,FIND(".",A2)+1)),A2,"").

This formula checks if there is a second period in the text string.    

If there is no second period, it returns the value from column A.      

If there is a second period, it returns an empty string.

2. In the first cell of the “Subdomain” column (let’s say it’s C2), enter the following formula: =IF(ISERROR(FIND(".",A2,FIND(".",A2)+1)),"",A2).

This formula checks if there is a second period in the text string.      

 If there is no second period, it returns an empty string.       

 If there is a second period, it returns the value from column A.

3. Drag these formulas down to fill the rest of the cells in columns B and C.

This should separate your list of domains and subdomains into two different columns.

See Example file.

Hope it has helped you!