This is as close as I can come. Array entered.If you aren’t familiar with array-entered formulae array enter means the formula must be committed from edit mode by simultaneously pressing and holding down Ctrl and Shift while hitting Enter.Formula:
=SUBSTITUTE(SUBSTITUTE(REPLACE(B2,1,MAX(IF((TRANSPOSE((ROW($97:$122)))=CODE(MID(B2,ROW(INDIRECT("1:"&LEN(B2))),1)))+ISNUMBER(--MID(B2,ROW(INDIRECT("1:"&LEN(B2))),1)),ROW(INDIRECT("1:"&LEN(B2)))))+1,""),"FLAVOUR TO NETWORK ","")," TRANSFER","")
Bookmarks