Special Characters And Symbols

1 minute read

You can always use the Insert –> Symbols method to enter characters onto your spreadsheet but you can also add them via a formula.

Formula

Result: Exchange Rates Chart (£), Euro (€) and Dollar ($)

="Exchange Rates Chart (" & CHAR(163) & "), Euro (" & CHAR(128) & ") and Dollar (" & (CHAR(36) & ")")

Using the below table as a guide, you can see that typing Alt + 0 + (code number) also produces the special character or symbol.

You can always put this in Row 1 and drag down to Row 255 for all symbols

  A B C D
1 Name Number Symbol Code
2 Quotation 34 *Alt + 0 + *34
3 Hash 35 # *Alt + 0 + *35
4 Dollar 36 $ *Alt + 0 + *36
5 Star 42 * *Alt + 0 + *42
6 Euro 128 *Alt + 0 + *128
7 Ellipsis 133 *Alt + 0 + *133
8 Dagger 134 *Alt + 0 + *134
9 Double 135 *Alt + 0 + *135
10 Bullet 149 *Alt + 0 + *149
11 Trademark 153 *Alt + 0 + *153
12 Cents 162 ¢ *Alt + 0 + *162
13 Pounds 163 £ *Alt + 0 + *163
14 Yen 165 ¥ *Alt + 0 + *165
15 Copyright 169 © *Alt + 0 + *169
16 Registered 174 ® *Alt + 0 + *174
17 Plus/Minus 177 ± *Alt + 0 + *177
18 Paragraph 182 *Alt + 0 + *182
19 Degree 176 ° *Alt + 0 + *176

Tags: text-strings

Categories: formulas

Updated: October 05, 2018

Twitter Facebook LinkedIn

Leave a Comment