Rich Text Formatting Is Lost When You Use Replace All
Article ID: 177194
Article Last Modified on 8/17/2005
APPLIES TO
- Microsoft Excel 2000 Standard Edition
- Microsoft Excel 97 Standard Edition
- Microsoft Excel 95 Standard Edition
- Microsoft Excel 5.0 Standard Edition
- Microsoft Excel 98 for Macintosh
This article was previously published under Q177194
SYMPTOMS
If you use the commands in the Replace dialog box to find and replace text
in a worksheet, some cells may lose their text formatting.
CAUSE
This problem occurs if the following conditions are true:
- On the Edit menu, you click Replace. In the Replace dialog box, you
type text in the Find What and Replace With boxes, and then click
Replace All.
-and-
- Some of the cells in the worksheet use rich text formatting,
which is a combination of font, font size, font
style (for example, bold or italic) and underlining formatting.
-and-
- You replace text in a cell that uses rich text formatting.
RESOLUTION
If you click Replace All, you cannot prevent Microsoft Excel from removing
rich text formatting from cells in which you replace text.
You can, however, use Find Next to find each cell that contains the text
you specify in the Find What box. When Excel finds the cell, click Replace
to replace the text in only that cell. If Excel finds a cell
that uses rich text formatting, click Close, manually edit the cell, and
then click Replace on the Edit menu to resume the process.
STATUS
Microsoft has confirmed this to be a problem in the Microsoft products
listed at the beginning of this article.
Additional query words: XL5 XL7 XL97 rtf XL
Keywords: kbprb KB177194