Method 1- using INDEX and SPLIT functions
Method 2- Using =IF(ISNUMBER(FIND("/", SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(B1, "www.", ""), "http://", ""),"https://", ""), 3)), LEFT(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(B1, "www.", ""), "http://", ""),"https://", ""), FIND("/", SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(B1, "www.", ""), "http://", ""),"https://", ""), 3) - 1), SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(B1, "www.", ""), "http://", ""),"https://", ""))
![](https://i.ytimg.com/vi/Uts8g0bbFIE/maxresdefault.jpg)