If you’d like to capitalize all letters in a cell, it’s easy – just use the following formula (assuming cell “A1″ has the text you want to capitalize).


How to capitalize the first letter in a cell in Excel:




Entering Symbols With The Keyboard

See Special Characters In Excel

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