XL: Trailing Gaps After Individually Formatted Characters

ID: Q189481

The information in this article applies to:

SYMPTOMS

You may see trailing gaps (spacing), which you did not type, between text characters you typed in a cell.

CAUSE

This problem can occur when you apply the Italic font style to one or more characters in a cell in which the characters are formatted with varying font sizes.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.

MORE INFORMATION

The gap is not a character and cannot be deleted. The gap appears at the end of a text fragment that has a different font size than the text fragment next to it. To illustrate this behavior, follow these steps:

1. Start Microsoft Excel.

2. Type the following into a new worksheet:

      A1:  aaaaaaaaa

3. Select the first three characters in the formula bar and change the
   font size to 12 by selecting 12 from the Font Size list box on the
   Formatting toolbar.

4. Select the three center characters in the formula bar and change the
   font size to 18. Then select the last three characters and change the
   font size to 24.

5. Select the entire text string and click the Italic button on the
   Formatting toolbar. Press ENTER.

Note that gaps appears between the italic characters of differing font sizes.

REFERENCES

For more information about the italic format, click Contents And Index on the Help menu, click the Index tab in Microsoft Excel Help, type the following text

   italic text

and then double-click the selected text to go to the "Change the size, font, color, or other text format" topic. If you are unable to find the information you need, ask the Office Assistant.

Additional query words: XL97 space xl7 xl5

Keywords          : kbdta
Version           : MACINTOSH:5.0; WINDOWS:5.0,7.0,97
Platform          : MACINTOSH WINDOWS
Issue type        : kbbug
Solution Type     : kbnofix

Last Reviewed: January 8, 1999