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.