Finding Positions of Formatted Characters in a Cell
With a little bit of work, Excel allows you to format individual characters of the text you place in a cell. If you want to later find which characters are formatted as, say, bold or italic, you'll need to use one of the macros provided in this tip.
Read this tip »
(Thanks to Steve Aprahamian, Juan de Frutos, David Shepherd for contributing to this tip.)