I have some data in A1 which I would like to strip off of some text blocks that occur between two specific words.

The text is from some json data so it's a mixture of text, numbers and special characters. But in my case, once the two words are identified, it's okay to remove everything between these words without specifying any pick - choose.

My approach that I tried.

I replaced the two words with two different delimiters and then applied the SUBSTITUTE, SEARCH and MID functions but doesn't work.

The formula is quite large and untidy in my opinion and probably there is a better way to do this.

The link