Microsoft KB Archive/105050
Excel: Trailing Space Added to Text Pasted into Find What Box
The information in this article applies to:
- Microsoft Excel for Windows, versions 4.0, 4.0a, 5.0, 7.0
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.
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
Version : 4.00 4.00a 5.00
Platform : WINDOWS
Issue type :
Last Reviewed: April 7, 1999