Hi Polly,
Your problem is quite analogous to the repeatedly discussed Chemical Legend.
Luckily enough, there are Chemical fonts that include numeral subscripts and
superscripts as individual characters. If you apply these specific fonts in
the place of your (most frequently used) basic fonts: Arial or Times New
Roman, you are able to write down chemical formulae, typographically almost
identical, without using any sub-/superscript modifications. You can then
reference such a string content of a cell in other cells, chart legend items,
axis names, etc., provided the both parts are formatted in the same or akin
Chemical font.
The accessible and usable Chemical fonts are two, AFAIK. The “Chemical
Serifâ€, which mimics Times New Roman, and the “Chemical SansSherifâ€, which
mimics Arial. They are so far free downloadable. The drawback of these fonts
is that they have --scripted numerals on the places that are not-easily
recognizable at input from keyboard. My proposal in
http://www.tech-archive.net/Archive/Excel/microsoft.public.excel.charting/2007-07/msg00189.html
was to use the “translator†in the form of subroutine. When called with the
cell selected, containing the chemical formula with properly scripted
numerals in the original font of the worksheet, the subroutine converts this
string into the Chemical font format, as described above. All the mentioned
references can then be built on this original (in some cases only auxiliary)
cell.
Hope it would help even other scholars
