XL: Rich Text Formatting Is Lost When You Use Replace All

Last reviewed: February 5, 1998
Article ID: Q177194
The information in this article applies to:
  • Microsoft Excel for Windows, versions 5.0, 5.0c
  • Microsoft Excel for the Macintosh, versions 5.0, 5.0a
  • Microsoft Excel for Windows 95, versions 7.0, 7.0a
  • Microsoft Excel 97 for Windows
  • Microsoft Excel 98 Macintosh Edition

SYMPTOMS

In 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.

CAUSE

This problem occurs if the following conditions are true:

  • On the Edit menu, you click Replace. In the Replace dialog box, you enter 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.

    NOTE: Rich text formatting 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.

When this problem occurs, Microsoft Excel removes the rich text formatting from the cell.

RESOLUTION

If 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.

STATUS

Microsoft 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 INFORMATION

You can apply rich text formatting to a cell in Microsoft Excel by following these steps:

  1. Select the cell and start editing the cell, by double-clicking the cell or by clicking the formula bar.

  2. Select the text that you want to format. On the Format menu, click Cells.

    The Font tab is displayed in the Format Cells dialog box that appears.

  3. Change the font.

    For example, make the font bold or increase the font size.

  4. Click OK. Then, press ENTER or RETURN (on a Macintosh computer) to enter the changes.

You can also select the text in the cell and use the tools on the Formatting toolbar to apply different fonts, font sizes, and so on, to the selected text.


Additional query words: XL5 XL7 XL97 rtf
Keywords : xlformat
Version : MACINTOSH:5.0,5.0a,98; WINDOWS:5.0,5.0c,7.0,7.0a,97
Platform : MACINTOSH WINDOWS
Issue type : kbprb


THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: February 5, 1998
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.