Special Characters in Excel

by Sanju 2009-10-13 12:21:37

Special Characters in Excel

Using a typical computer keyboard, you can directly type in approximately 94 different characters, 
such as letters and number other symbols like punctuation marks.

If you know the code number, you can enter that character any time by holding down the ALT key, and typing
the 4-digit code number on the numeric keypad (the keys on the far right of your keyboard -- do not use the
\"normal\" number keys above the letter keys). Even though character code numbers are only three digits
(between 0 and 255), you must type in the leading zeros to ensure that you get the proper character.
For example, to enter in the British Pound sign, whose code is 163, hold down the ALT key, and type 0163 on the numeric keypad.
Common Symbols And Codes

Euro 0128
Ellipsis 0133
Dagger 0134
Double Dagger 0135
Bullet 0149
Trademark 0153
Cents 0162
Pounds 0163
Yen 0165
Copyright 0169
Registered 0174
Plus/Minus 0177
Paragraph 0182
Degree 0176

Using Symbols In Formulas
If you need to use a special symbol in a worksheet formula, you can use the function to return the
character from its code number. For example, suppose you want to add a copyright notice to your worksheet.
You could use the following formula:

=CHAR(169)


or

> Goto Insert -> Symbols and insert the symbols which you want.

Tagged in:

1742
like
0
dislike
0
mail
flag

You must LOGIN to add comments