google sheet need formula to go backward directory of URL link stackoverflow

Recent Questions - Web Applications Stack Exchange

example i have data in colum c2 https://www.mybookStore.com/images/products/80/1020/40422/2/279/howtocookegg8.jpg https://www.mybookStore.com/images/products/80/1020/40422/2/279/howtocookegg9.jpg

i need the formula that can go backward one or two directory in url link, so the result would be:

https://www.mybookStore.com/images/products/80/1020/40422/2/howtocookegg8.jpg https://www.mybookStore.com/images/products/80/1020/40422/howtocookegg9.jpg

please help, thanks you.


Recent Questions - Web Applications Stack Exchange Recent Questions - Web Applications Stack Exchange by extreemblank via Recent Questions - Web Applications Stack Exchange

No comments:

Post a Comment