How do I insert em dash in Excel?

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

On Wed, 27 Oct 2004 12:55:07 -0700, janevw
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

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
wrote:

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

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)