Formula to Get a Domain Name from a URL in Libreoffice, Excel, and Google Sheets (With Generator!)

Wednesday - July 18, 2018

Enter the cell that contains your URL and the formula to get the domain name will be generated below.

Javascript is disabled in your browser! Either enable Javascript and you'll be able to interact with the formula below - or copy the formula and replace all instances of {{cellValue}} with your desired cell (The cell that contains your URL).

Cell:

=IF(ISNUMBER(FIND("/", SUBSTITUTE(SUBSTITUTE(SUBSTITUTE({{cellValue}}, "www.", ""), "http://", ""),"https://", ""), 3)), LEFT(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE({{cellValue}}, "www.", ""), "http://", ""),"https://", ""), FIND("/", SUBSTITUTE(SUBSTITUTE(SUBSTITUTE({{cellValue}}, "www.", ""), "http://", ""),"https://", ""), 3) - 1), SUBSTITUTE(SUBSTITUTE(SUBSTITUTE({{cellValue}}, "www.", ""), "http://", ""),"https://", ""))

About this formula: I used Lisp to help create it.