The whole formula as you posted, is quite sophisticated. It won't work with numeric values, unless you change REPT("z",255) to - for example - 9^9
******

Try this A1:A10
a1a11a1df12b1qwe12bccasdasd102aasd1ws


with this E1:E10
wedfqwfghhtr2a1a1asdrrr2ddd


You get
a1a1a1ANOTHER VALUEqwANOTHER VALUEasdasdANOTHER VALUEasd

That is only 2 results correct!
Is it a sophisticated formula?
Bad formula and bad analysis!

Bruno