Forum Discussion
Excel Subscripts/Superscripts
Thank you! You are correct. However, when say cell A2 uses the formula = A1, it loses the subscript format. Or when cell A2 uses a formula to obtain the value in cell A1, it also loses the subscript format.
Yes, that is what I tried to convey in my previous reply. A formula such as =A1 returns only the value of A1, not its formatting. If A1 contains MSNp, there is no way to make the p to be subscripted in the cell with the formula =A1
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.