Hello,
I'm using substitute nested many times to turn formulas with cell references into equations with text. It's a multipart process starting with a formula-to-text function generating a secondary array, some other stuff, and then a huge string of nested substitute functions generating a third array with the equations.
However, substitute seems to only reference the first two digits regardless of what i do.
For instance running =SUBSTITUTE(SUBSTITUTE(E8,"c14"," yes"),"c144", "no") on two cells, one with c14 and one with c144 properly returns yes for the first, but for the second returns yes4. So it seems to be only evaluating the first two digits, falsely recognizing the second cell as "c14" replacing that and leaving the additional 4.
Is there a solution to this problem? Any help would be greatly appreciated.
I'm using substitute nested many times to turn formulas with cell references into equations with text. It's a multipart process starting with a formula-to-text function generating a secondary array, some other stuff, and then a huge string of nested substitute functions generating a third array with the equations.
However, substitute seems to only reference the first two digits regardless of what i do.
For instance running =SUBSTITUTE(SUBSTITUTE(E8,"c14"," yes"),"c144", "no") on two cells, one with c14 and one with c144 properly returns yes for the first, but for the second returns yes4. So it seems to be only evaluating the first two digits, falsely recognizing the second cell as "c14" replacing that and leaving the additional 4.
Is there a solution to this problem? Any help would be greatly appreciated.
