I'm trying to set up a formula to extract data from a URL that is in one of the column B of my Google Sheet.
I've been tryin use the LEFT formula to extract the data, but the problem is that the string I am trying to extract can be different in size. I couldn't find a formula that can extract between two substrings.
In this example, I want to pull out the Subreddit which occurs in every URL, after the substring: "https://www.reddit.com/r/" and before the ensuing "/". So the output value for C2 would be "AskReddit".