Special characters

[Matthew S]

What is the option / tool that makes a (C) show as a circled C?

 

[Paul Sheppard]

What is the option / tool that makes a (C) show as a circled C?

Hi Matthew

You can get a circled C from the Character Map

Start > Programs > Accesories > System Tools and change the font t
Symbo

 

[Dave O]

Not an option or tool, as much as finding the right font and the right
keystroke. This is unfortunately a brute force approach: change to
Wingding font, and start pressing keys until you get a circled C.

 

[Norman Jones]

Hi Mathew,

With the Alt key depressed, use the number key pad to type 184

 

[Bob Phillips]

It is normally an entry in Autocorrect entry, so typing (c) does it
automatically.

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Matthew S]

Thank you all for your responses. I learned something from each, but not
exactly what I was hoping to learn. I'm very new at this approach to
learning. I'm sure, now, that my question was too vague.

I'll try it again with more detail.

In my studies, I came across a dialog box that seemed to set things up so
that if you type in a C in parentheses, a circled C is what is displayed. I
couldn't relocate the page so I thought I'd ask the community.

If I type a (C) in a cell, Excel displays © instead. This is true whether uc
or lc C is used. However, if I type (B) or (A) in a cell, Excel displays (B)
or (A).

What would have to be changed to get (C) to display when that is what I type
in the cell?

 

[Bob Phillips]

Remove the autocorrect entry.

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Matthew S]

THAT'S IT - Thanks a lot Bob!

It is normally an entry in Autocorrect entry, so typing (c) does it
automatically.

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Lin]

Hi Norman,

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.

Regards
Lin

 

[Debra Dalgleish]

Jon Peltier has an ASCII table that you can download, with all the
character codes:

http://www.peltiertech.com/Excel/tricks.html

 

[Jay]

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).