Excel Guides

How to Insert Symbols in Excel

There are a few ways to insert symbols in Excel. One way is to use the Symbol dialog box. To do this, click the Insert tab on the ribbon, then click Symbol. The Symbol dialog box will appear. In the dialog box, select the symbol you want to insert, then click Insert. The symbol will be inserted at the cursor location.

Another way to insert symbols in Excel is to use alt codes. To do this, hold down the Alt key and type the four-digit code for the symbol you want to insert. For example, to insert the copyright symbol , you would hold down Alt and type 0169. When you release the Alt key, the symbol will be inserted at the cursor location.

You can also use Unicode characters to insert symbols in Excel. To do this, press Alt+F11 to open the Visual Basic Editor. In the editor, click Insert > Module. Paste the following code into the module:

Public Function Unicode(ByVal i As Integer) As String 
  Dim s As String 
  s = ChrW(i) 
  Unicode = s 
End Function

Now you can use the Unicode function in your worksheet formulas. For example, to insert the copyright symbol in cell A1, you would enter =Unicode(0169) in that cell.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.