Microsoft KB Archive/51341

From BetaArchive Wiki

Excel: Ampersand (&) Does Not Appear Using INPUT Command

Last reviewed: October 31, 1994
Article ID: Q51341


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


Additional reference words: 2.20 3.00

Last reviewed: October 31, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.