Microsoft KB Archive/51341

Excel: Ampersand (&) Does Not Appear Using INPUT Command Last reviewed: October 31, 1994 Article ID: Q51341

SUMMARY When an ampersand (&) is used in an INPUT command within a macro sheet in Microsoft Excel versions 2.20 and 3.00, the ampersand does not show in the resulting dialog box; instead, it appears to be parsed. For example, the text in the resulting dialog box in the following macro would read "Enter first last name.": =INPUT("Enter first & last name.",2) To have an ampersand appear in a dialog box, enter double ampersands: =INPUT("Enter first && last name.",2)

KBCategory: kbother KBSubcategory: Additional reference words: 2.20 3.00 Last reviewed: October 31, 1994 © 1998 Microsoft Corporation. All rights reserved. Terms of Use.