How do I insert em dash in Excel?
how do I insert em dash or en dash in Excel?
Leave a comment...
- 3 Comments
- On Wed, 27 Oct 2004 12:55:07 -0700, janevw <janevw.excel.todaysummary.com.discussions.microsoft.com>
>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.
=CHAR(150) (en dash)
=CHAR(151) (em dash)
--ron#1; Thu, 22 May 2008 22:30:00 GMT
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>
>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
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
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.
Bill -- (Remove KILLSPAM from my address to use it)#3; Thu, 22 May 2008 22:33:00 GMT