Hi,
As my subject says ... In Excel 2002, when I have bold and non-bold text in the same cell, and I do a Replace of a word or phrase of the non-bold text, the entire cell gets formatted non-bold ... or sometimes as bold! This looks like a bug to me. Since it happens the very first time I use Replace in a given session, there's no reason to expect any format to be set in the Replace dialog, and in fact there isn't. Not that it would really explain this effect if settings were being changed arbitrarily. The effect goes beyond what would even appear to be possible with the Replace dialog box. Is there a fix or workaround for this?
Thanks,
Gregg Roberts
As my subject says ... In Excel 2002, when I have bold and non-bold text in the same cell, and I do a Replace of a word or phrase of the non-bold text, the entire cell gets formatted non-bold ... or sometimes as bold! This looks like a bug to me. Since it happens the very first time I use Replace in a given session, there's no reason to expect any format to be set in the Replace dialog, and in fact there isn't. Not that it would really explain this effect if settings were being changed arbitrarily. The effect goes beyond what would even appear to be possible with the Replace dialog box. Is there a fix or workaround for this?
Thanks,
Gregg Roberts
. The article says that it applies to Excel 2000 but it seems to apply to XP as well -- perhaps even more broadly, as it is not only Replace All but even a single Replace that causes the issue.