Excel: Trailing Space Added to Text Pasted into Find What Box

ID: Q105050

The information in this article applies to:

Microsoft Excel for Windows, versions 4.0, 4.0a, 5.0, 7.0

SYMPTOMS

In Microsoft Excel, when you copy text directly from your worksheet and paste it into the Find What box in the Find dialog box (from the Formula menu, choose Find), the pasted information will contain a trailing space.

WORKAROUND

To work around this situation, copy the text from the formula bar and then paste the text into the Find What box.

Additional query words: 4.00a 7.00 extra blank replace with character


Keywords          : 
Version           : 4.00 4.00a 5.00
Platform          : WINDOWS 
Issue type        :

Last Reviewed: April 7, 1999