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: 4.5.0.0.alpha0+ Build ID: 170616e9f2d30c1302bbb5a7a4b588bc05cd5cc9 TinderBox: Win-x86@39, Branch:master, Time: 2014-12-12_01:58:46