How to Add Dash in Excel

For some things in Excel, there are several ways in which they can be done. Such is the case with formatting, usually. One such thing is also adding a symbol.

We will show this in the example of adding a dash in Excel.

Add Dash in Excel

There are two types of dash in Excel: en-dash (“– “) and em-dash (“—“). The first way to create any of these two is to Insert tab >> Symbols >> Symbol:

Graphical user interface, application, Word, Excel

Description automatically generated

On the pop-up window that appears, we have two tabs: Symbols and Special Characters. We will go to the second tab (Special Characters):

Graphical user interface, text, application

Description automatically generated

When you open this window, the first thing that can be seen are Em and En dash. To insert them, we need to choose and click Insert. That simple. We will do just that in cells A1 and A2, and this is the result we will end up with:

A picture containing application

Description automatically generated

There are also two more ways to insert dashes in Excel: 1) Using a numeric keypad; 2) Using a formula.

  1. Some laptops don’t have a numeric keypad. On the ones that do have this option, you can create dashes using the following combination:
En- dash: ALT + 0150
Em- dash: ALT + 0151
  1. Using formulas is maybe the easiest and most convenient option for inserting dashes. The formulas are as follows:
En- dash: =CHAR(150)
Em- dash: =CHAR(151)

As can be seen in the picture below:

Graphical user interface, text, application, chat or text message

Description automatically generated

Formulas are also the best way to combine dashes with some text. For example, if we insert this text in cell A6:

="This text will be separated" & CHAR(151) & "by a dash"

This is our end product:

Graphical user interface, application, table

Description automatically generated