Is there a RegEex solution to accomplish the following:
- Assuming Operator Pattern is "[/*^&()=<>,+-]"
- Cell References are pre-fixed Post-fixed by an Operator (including a comma)
- Cell References Start with Alpha Characters without-interruption - by an operator
then Followed by numerics-without-interruption - by an operator
----------------------FORMULA STRING INPUT----------------| |---OUTPUT---|
Cell
Cell
1) =I82*I83/365*0.11 < < < < < < < < < < < < > I82 I83
2) =IF(H84>H80*0.91,H84,0.91*H80) < < < < < < < < >&nbs
View Complete Post