Forum Discussion
Excel Subscripts/Superscripts
How does one retain subscripts and superscripts when copying or using a formula to copy text from one cell to another? For example, assume cell A1 contains the text "MSNp" where the "p" is subscripte...
Unfortunately, that leaves me stuck with manually subscripting characters, which is not practical for the dynamic generation of the main effect and interaction labels. I wonder if a work-around might be the concatenation of a text string with a unicode for a subscripted alphabetical character, where the unicode character is a close approximation to the font type of the character string. I know a source for unicodes for subscripted numerical characters, but not for subscripted alphabetical characters.
It looks like only a few letters are available as subscripted characters - see Superscript and Subscript Letters
- Thanks very much. I will look into the possibility of creating additional unicode text.