Excel: CTRL Key Doesn't Yield Alternate Character Set
ID: Q43501
|
SUMMARY
Several fonts use the CTRL key as a modifier to access alternate
characters; for example, CTRL+Q is a cloverleaf in the Chicago font.
In Microsoft Excel versions 2.2, 3.0 and 4.0, the CTRL key is mapped
to the COMMAND+OPTION key combination for executing user-defined
macros. Therefore, the CTRL key can not be used to access alternate
characters.
If the ASCII code of the alternate characters is known, it can be
placed in the Excel document using the CHAR() command.
Note
If you have Microsoft Word, the ASCII code of any character can be
found by:
- Type the character and select it.
- Press COMMAND+OPTION+Q.
- Look in the bottom-left corner to see the ASCII number.
MORE INFORMATION
For example, do the following to enter the cloverleaf (ASCII 17 in the
Chicago font) into a cell:
- Type the following into the cell:
=CHAR(17)
- Hold down the COMMAND key and press the EQUAL SIGN (=) key
(Calculate Now). The formula bar should contain a box.
- Press the ENTER key on the numeric keypad so that the text is
entered but the same cell remains selected.
- From the Options menu, choose Font and click Chicago.
- Click OK.
The cell will now show the cloverleaf. A box will show in the formula
bar because the formula bar uses the Geneva font, in which ASCII 17 is
not defined. Undefined characters are always displayed as a box.
Additional query words:
2.2 2.20 3.0 3.00 4.0 4.00 control
Keywords :
Version :
Platform :
Issue type :