How do I insert em dash in Excel?

R

Ron Rosenfeld

how do I insert em dash or en dash in Excel?
Click to expand...

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
 
G

Gord Dibben

jane

en dash is ALT + 0150(on NumPad)

em dash is ALT + 0151

Gord Dibben Excel MVP
 
B

Bill Martin

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)
 
Top