Hi guys. This is my first time here.

I have this requirement. say I have a text in a cell, i want to be able to select part of the text, right-click and run a macro to replace the selected text.

For example, if i have "102 * 100 = abc" in a cell, i select just the "2", right click, select my custom item in the context menu which replaces "2" with "<sub>2</sub>".

In my search, I learnt that macros are not possible in edit mode. how can i achieve my aim.

Thanks guys!!