Results 1 to 4 of 4
  1. #1
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Vienna, Wien, Austria
    Posts
    5,009
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Ampersand in Header (any)

    In dealing with a company name that has an ampersand: M&S, Excel has a "feature" that is convinced that & is a print instructions character. Placing single or double quotes - or spaces - around the ampersand simply produces amendments to the print instrcutions. Is there an actual workaround - or is this an entrenched "feature".
    Gre

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Ampersand in Header (any)

    Use dbl ampersands:

    M&&S

    Steve

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Ampersand in Header (any)

    The "usual" trick of doubling the ampersand seems to work here too: M&&S becomes M&S when previewed and printed.

  4. #4
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Vienna, Wien, Austria
    Posts
    5,009
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Ampersand in Header (any)

    <img src=/S/thumbup.gif border=0 alt=thumbup width=15 height=15>! Many thanks.
    Gre

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •