How to Add Special Characters in Excel

The special characters in Excel can be understood in different ways. How to deal with it when using it depends on the person using it.

Special character in formula

In this example, we have legal issues, our sales have been requested by an investor, and we want to inform the investor that the document is protected by a copyright.

Our data looks like this:


Click on the middle of the data (1), type in =char(169) & “Copyright Jennifer Corporation 2014”.

copyright special character

This is how to add copyright symbol to Excel formula. The same way you can add other symbols.

Inserting the Symbol

You can insert symbols such as mathematical symbols, currency symbols, and more, into a cell by using the “Insert Symbol” option. To do this, go to the “Insert” tab on the Excel ribbon and click on the “Symbol” button in the “Text” group. In the Symbol dialog box, select the symbol you want to insert and then click “Insert.”

Keyboard Shortcut

You can also use keyboard shortcuts to insert special characters in Excel. For example, you can hold down the Alt key and type a number code to insert a symbol.

Using the CHAR function

The CHAR function in Excel can be used to insert special characters into a cell. The CHAR function takes a number as an argument and returns the corresponding ASCII character. For example, the formula “=CHAR(169)” will return the copyright symbol (©).

See also  How to Open MPP File in Excel

Using the Wingdings Font

The Wingdings font in Excel contains a number of special characters and symbols that can be inserted into a cell. To insert a symbol from the Wingdings font, select the cell, go to the “Home” tab on the Excel ribbon and choose the “Wingdings” font in the “Font” group. Then, type the symbol you want to insert.

Note: To quickly find the number code or the symbol you need, you can search for it on the Internet or consult the ASCII table or the Wingdings chart.