Tags: dash, excel, insert, microsoft, msdn, software

How do I insert em dash in Excel?

On Microsoft » Microsoft Excel

1,341 words with 3 Comments; publish: Thu, 22 May 2008 22:29:00 GMT; (30693.75, « »)

how do I insert em dash or en dash in Excel?

All Comments

Leave a comment...

  • 3 Comments
    • On Wed, 27 Oct 2004 12:55:07 -0700, janevw <janevw.excel.todaysummary.com.discussions.microsoft.com>

      wrote:

      >how do I insert em dash or en dash in Excel?

      Hold down the <alt> key and type 0150 on the numeric keypad for en dash; 0151

      for em dash.

      or

      =CHAR(150) (en dash)

      =CHAR(151) (em dash)

      --ron

      #1; Thu, 22 May 2008 22:30:00 GMT
    • jane

      en dash is ALT + 0150(on NumPad)

      em dash is ALT + 0151

      Gord Dibben Excel MVP

      On Wed, 27 Oct 2004 12:55:07 -0700, janevw <janevw.excel.todaysummary.com.discussions.microsoft.com>

      wrote:

      >how do I insert em dash or en dash in Excel?

      #2; Thu, 22 May 2008 22:31:00 GMT
    • People have given you the ASCII Alt codes which work well, but I find a bit

      arcane and difficult to remember. Computers should do that sort of thing for

      you now.

      What I typically do instead is just bring up an example of the font then copy

      the character from that and paste into my Excel sheet. This approach also

      allows you to copy in special characters which may not be in the Arial

      default font.

      My personal choice of a program to look at all the characters in a font to

      select from is the freeware "Karen's Font Explorer", but there must be a

      thousand others out there to choose from.

      Good luck...

      Bill -- (Remove KILLSPAM from my address to use it)

      #3; Thu, 22 May 2008 22:33:00 GMT