What function can I use to extract variable length strings, where all I know is the beginning and end points of the string.
So for example, I have a large list of domain names formatted like below, and I need to extract everything between the “://” and the “/” that occurs after the “.com”. One condition is that I also have some domain names in the same list that end in “.net” or “.ca” that need to be extracted similarly.
Excel Find & Mid functions for variable length strings
microsoft excel
Best Answer
Use this: