Microsoft KB Archive/51341

{| = Excel: Ampersand (&) Does Not Appear Using INPUT Command =
 * width="100%"|

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 &quot;Enter first last name.&quot;:

=INPUT(&quot;Enter first & last name.&quot;,2) To have an ampersand appear in a dialog box, enter double ampersands: =INPUT(&quot;Enter first && last name.&quot;,2)
 * }