Anyway to optimize the formula

[arno911]

Goal: to extract text between {{}} from a block of text.

Input: Lorem ipsum dolor sit amet, {{consectetur}} adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in {{reprehenderit}} in voluptate velit esse cillum dolore eu fugiat {{nulla}} pariatur. {{Excepteur}} sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id {{est}} laborum.

=REPLACE(LEFT(C4,FIND("}}",C4&"}}")-1),1,FIND("{{",C4&"{{"),"")&REPLACE(LEFT(C4,FIND("#",SUBSTITUTE(C4&REPT("}}",2),"}}","#",2))-1),1,FIND("#",SUBSTITUTE(C4&REPT("{{",2),"{{","#",2)),"")&REPLACE(LEFT(C4,FIND("#",SUBSTITUTE(C4&REPT("}}",3),"}}","#",3))-1),1,FIND("#",SUBSTITUTE(C4&REPT("{{",3),"{{","#",3)),"")&REPLACE(LEFT(C4,FIND("#",SUBSTITUTE(C4&REPT("}}",4),"}}","#",4))-1),1,FIND("#",SUBSTITUTE(C4&REPT("{{",4),"{{","#",4)),"")&REPLACE(LEFT(C4,FIND("#",SUBSTITUTE(C4&REPT("}}",5),"}}","#",5))-1),1,FIND("#",SUBSTITUTE(C4&REPT("{{",5),"{{","#",5)),"")

Output: {consectetur{reprehenderit{nulla{Excepteur{est

Can this formula be also made to accommodate infinite items?

 

[Fluff]

For 365 how about

="{"&TEXTJOIN("{",,INDEX(TEXTSPLIT(C4,"{{","}}",1,,""),,2))

 

[arno911]

wow. i have been losing my mind over this for so long. thank you so much Fluff

 

[Fluff]

You're welcome & thanks for the feedback.