The “Process Text” Button. Formatting characters as a subscript or superscript or as a Greek character is a bit tedious in Excel. So this handy little button will do quickly for you. It a development of some original work done by ExcelCalcs user Mike Lawson.
Process Text Rules
Precede any character with “|” and it will become a Greek character.
Precede any character with “^” and it will be superscripted.
Precede any character with “_” and it will be subscripted.
Finally all characters enclosed between square brackets “[” and “]”will be subscripted.
Precede any character with “^” and it will be superscripted.
Precede any character with “_” and it will be subscripted.
Finally all characters enclosed between square brackets “[” and “]”will be subscripted.
The process text button works for text in worksheet cells, text in drawing objects and text boxes and text in chart titles and chart axis. The text string must be 255 characters or less to be processed.
Play movie - Format shortcuts for mathematical notation | |
An XLC tool to help us format cells, textboxes and charts with mathematical notation. |