There is a VBA function that permits addressing individual characters...
.Value = "abcdefg"
.Characters(3, 1).Font.Bold = True
You could construct a string and copy it to a cell, then address individual
characters as shown using the Characters function which enables one to set
size, font, color, bold, underline, etc.