View Single Post
  #11   Report Post  
Jay
 
Posts: n/a
Default

How can I get a full list of special characters available using
ALT/CTL/Shift and the number key pad? Thanks very much in advance.


I made myself a character map spreadsheet for this purpose, like this:

In A1, put
=ROW()
and copy down to A255. For this column, use
Format Cells Number Custom 000

In B1, put
=DEC2HEX(A9,2)
and copy down to B255 in case you want the hexadecimal value sometime.

In C1, put
=CHAR(ROW())
and copy down to C255.

Hide rows 1-8, 11-12, 14-31. They aren't useful.

Put the following in the indicated cells for special characters:
C9 ... "Tab"
C10 ... "LF"
C13 ... "CR"
These are the tab character, line feed, and carriage return.

Look at rows A and C to answer your question.

You can also
Copy
and
Paste Special Values
from the character map to another excel spreadsheet, or just
Paste
into Word.

To see special characters in other fonts, you can copy column C into
several more columns, and (from row 33 on) format each column with a
different font (like Symbol or Wingdings).