Hi All,

I was recently shown a way to extract specific text between delimiters using only a formula, but I can't for the life of me remember it.

For example, if I have the following text:

ONE/TWO/THREE/FOUR

and I would like to extract the third field 'THREE' then I can use a formula in another cell to do this. Does anyone know what this formula is?

Moreover, does anyone know how I could fit this formula into an INDEX MATCH function? That is to say, my current index match is picking up the entire string 'ONE/TWO/THREE/FOUR' but I want it to pick up only the third field