Forum Discussion
Name Manager accomodate Uncodes to follow Excel syntax
IMHO, only choice for users (VBA restricted by company policy) is labour-intensive naming intuitive to other users; one challenge: Unicode required to emulate Excel function style. Example is Excel ...
I'm not sure I understand what you are asking for exactly?
I use Unicodes to name my formula to visual match name as Excel Function so that others viewing formula bar of cell know what it does without clicking anywhere else.
Excel SUBSTITUTE(text, old, new) function replace text containing string "old" with string "new".
My formula accepts array for string "old" and string "new".
SUBSTITUTE﹙txt﹐﹛old﹜﹐﹛new﹜﹚ replace text containing string_array "old" with string_array "new".
Following are Unicodes ﹙﹛﹜﹐﹛﹚ but I wish Excel allow other Unicodes that are more visually suitable. I can provide more details if this is not impossible wish.
Excel SUBSTITUTE(text, old, new) function replace text containing string "old" with string "new".
My formula accepts array for string "old" and string "new".
SUBSTITUTE﹙txt﹐﹛old﹜﹐﹛new﹜﹚ replace text containing string_array "old" with string_array "new".
Following are Unicodes ﹙﹛﹜﹐﹛﹚ but I wish Excel allow other Unicodes that are more visually suitable. I can provide more details if this is not impossible wish.