Look for the "Characters" collection, which presents the text of a cell as a
collection of characters.
--
John Huschka


"roadkill" wrote:

The user interface for Excel allows you to select letters or words within a
string of text in a cell and change the format (bold, color, etc.) for just
the selected letters or words. I haven't been able to figure out how to do
this same selective formatting programmatically. Does VBA provide this
capability and, if so, how?

Thanks,
Will