XL: Rich Text Formatting Is Lost When You Use Replace AllLast reviewed: February 5, 1998Article ID: Q177194 |
The information in this article applies to:
SYMPTOMSIn the versions of Microsoft Excel listed at the beginning of this article, 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.
CAUSEThis problem occurs if the following conditions are true:
RESOLUTIONIf you click Replace All, you cannot prevent Microsoft Excel from removing rich text formatting from cells in which you replace text. However, you can use Find Next to find each cell that contains the text you specify in the Find What box. After you find the cell, click Replace to replace the text in only that cell. If Microsoft 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.
STATUSMicrosoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.
MORE INFORMATIONYou can apply rich text formatting to a cell in Microsoft Excel by following these steps:
|
Additional query words: XL5 XL7 XL97 rtf
© 1998 Microsoft Corporation. All rights reserved. Terms of Use. |