Excel 2007 - Chemical formulae entered in cells using format to show
subscript, however normal font shows on formula bar. When copied and pasted
elsewhere, or when used in chart subscript characters show as normal font.
Help!

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/.../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

--
Petr Bezucha


"Polly" wrote:

Excel 2007 - Chemical formulae entered in cells using format to show
subscript, however normal font shows on formula bar. When copied and pasted
elsewhere, or when used in chart subscript characters show as normal font.
Help!