I have this formula (Spanish version): =DERECHA(C4;ENCONTRAR(" ";C4))
Then I click on the Formula Editor pressing the fx button in the formula bar. It has 3 parts:
A. Formula tree in the left panel.
B. Formula code in the bottom box.
C. Formula form.
If I click on DERECHA or ENCONTRAR in the code (B), then the form (C) updates correctly to that part of the formula.
If I click on any part of the formula in the tree (A), it has no effect. I think it should change the form (C) too.
Please tell me the English equivalents of DERECHA and ENCONTRAR or attach a document I can test.
It should be DERECHA=RIGHT & ENCONTRAR=FIND if I'm not wrong.
Thanks. I confirm and think it's a reasonable enhancement request.
Win 7 64-bit Version: 18.104.22.168.alpha0+
Build ID: 170616e9f2d30c1302bbb5a7a4b588bc05cd5cc9
TinderBox: Win-x86@39, Branch:master, Time: 2014-12-12_01:58:46