Article ID: 177194 - View products that this article applies to.
This article was previously published under Q177194
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.
This problem occurs if the following conditions are true:
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.
Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.
How to Apply Rich Text Formatting to a Cell in Microsoft Excel
Article ID: 177194 - Last Review: August 17, 2005 - Revision: 1.3