How do I insert em dash in Excel?

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

En and Em dashes 9
Excel 2003 assign keyboard shortcuts to specific special character 1
Word Dashed line formatting 0
How do I create a formula to remove dashes? 6
Find and replace Em dash. 9
ASAP Dash portable 0
how do i delete dash in phone numbers 3
Displaying zeros in cells 2

Back
Top