Hi, RobiNew! I'm sorry Greg's answer hurt your feelings. I've reread his post and may conclude that he didn't mean anything to insult you. It's the disadvantage of written texts: they can be read with the intonation different from the author's. However it's only my opinion. We are all here to help each other according to our knowledge and experience. Let me offer one more solution to your request as I understand it. The code is a modification of yours as you asked. It inserts a superscripted 'a' before the space that precedes ftNote, i.e. after the ftNote number. If this is not what you want, please, specify the task in more details.
Code:
With ftNote.Range
.Characters.First.Previous = supLetter & Chr(32)
.Characters.First.Font.Superscript = True
End with