Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm wondering if these is a way of using a formula to find a superscript letter, rather than just the last letter of a word.

I have lots of tabs, with nearly matching tables on each one showing up to 34 categories. These categories can have footnotes attached to them. To show tha a footnote is attached a 'superscript' letter is added just after the category name (nothing new there).

Unfortunatley these footnotes have become out of control and the people who managed this file before me just stop putting them in order. So I am therefore going to change the system. Rather than a footnote I'm just using an asterix next to the category, and the category name will be used below in the footnotes - makes more sense and is easier to manage!

I'm now thinking of the quickest way to manage this massive task and keeping integrity with the footnotes. I'm wondering if these is a way of using a formula to find a superscript letter, rather than just the last letter.

If I could do this then I could use another one to extract the category name - up until the superscript letter. I could then more easily cut & paste footnote letters with category names.

Any ideas or suggestions gratefully appreciated.

Thanks Mike.

share|improve this question

Are you willing to use VBA macros ? If yes, there is a "Font.Superscript" function you could test.

share|improve this answer
I'm certainly open to ideas, but VBA is not something I meddle with very much - not without help from others from this forum anyway. – RocketGoal Apr 19 '11 at 10:38
@Mike: This is not a forum but a Q&A site. The only way to approach this is by scripting, since you are asking something very specific. Visual Basic is no rocket science, some simple Googling will get you there... :) – Tom Wijsman Apr 1 '12 at 11:11

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.