So let's say I have a formula "=A1/5" and I want to change it to "=A1/sqrt(5" i.e. inserting something at the second last position.
(subsequently I can do a simple = cell&")" to complete the formula).
I managed to do it but I took a very lengthy route, so wonder if anyone has idea how to quickly accomplish this.
My approach now:
Deformularize by replacing "=" with "" aka nothing.
Extracting the left part and rightmost part of the string separately by =LEFT(cell,LEN(cell)-1) and =RIGHT(cell,1)
- For the rightmost part extracted (which is a single digit number), I simply do a ="sqrt("&cell
- I then concatenate together a "=", the extracted left part and the amended right part.
this works, but as you can see, it took quite a bit of work.