Superscripts in referenced text objects

[PBezucha]

Dear,
Several days ago a question appeared in this NG on the superscripts in
referenced text objects. The answers correctly recommended looking for
sub-/superscript font sets. What does it mean? Optimally such a font set
should contain at least all the 34 alphanumeric characters within the second
128 ANSI locations as both kinds of those scripts. Has anybody ever come
across such a product? I succeeded several months ago, after the
recommendation of Bernard Liengme, in adopting Chemistry fonts (“Chemistry
SansSherif†and “Chemistry Sherifâ€). They offer unfortunately only numerals
in wanted scripts. Nevertheless it is pleasing e.g. for fixing chemical
formulae correctly. Therefore I even made then up a macro for facilitating
the transcription from the referred cell, where the text was written in the
basic font, and put it on the thread. On my supplementary question about the
better font set, only one indefinite answer came that led to nothing. Aren’t
then such sorts of recommendation, as to google for possibly not existing
products, in fact only a royal advice, good for a greater puzzlement of
current users? Let us bring this matter to a (by this time) definite
solution.

 

[Peter T]

Unless another reader happens to know of a Font such as you describe, I
imagine to find it would indeed require a bit of Google research. I guess
you'd be as well equipped as anyone so perhaps you might like to have a go
and post for posterity a "definite solution".

Keep in mind that if any 'solution' needs to be portable other users would
also need the same Font.

In the meantime, or failing a search unearthing such a Font, most text
objects in Excel can be formatted with mixed font formats. Ie a cell or
textbox can contain text with a mixture of normal, size, sub/superscript,
bold, italic, colour (etc) characters. There are no portability issues with
this approach.

As you are posting in 'charting', chart titles and data labels also support
mixed fonts, though not axes or series names in legends. Of course no
problem to insert mixed font text-boxes if/as required.

Regards,
Peter T

 

[Jon Peltier]

I've seen such fonts, but they only contain sub- and superscripted numerals,
and maybe the occasional letter.

The problem here is that you could format the text character by character,
but not without breaking the link to the source text. You can get around it
using VBA, and being careful to update the text when needed.

The way I've done this using VBA is to have the code copy the value from the
cell (text only), insert it without a link into the label (linked content
cannot support separate formatting within the text), then step through the
cell's text character by character, and apply the formatting to the label's
text character by character. If the formatting involves more than just a
couple formatting properties (i.e., bold, italic, color, font name, sub- and
superscript), the label will lose some of the formatting of the cell. This
works with data labels, axis and chart titles, shapes (including textboxes),
but not with axis tick labels. But you can fake those with data labels.

If your only real font property of interest is sub- and superscripting, it
should
work well enough.

- Jon

 

[PBezucha]

Well, the discussion should have not been about the direct records, where
formatting each character is elementary. Please correct possibly my "still
not founding" a better font set (except quoted "Chemistry" ones with numerals
restriction).
Thank you for the interest.