Symbols used in Excel?

A

angelaj

Can anyone tell me how to incorporate symbols into a
spreadsheet? I know there is a way to use key
combinations to have information represented as "degrees"
but if that one exists, what others are out there? I had
someone ask me how to show the "trademark" symbol, or
the "register" symbol? There must be a tips and tricks
list somewhere showing these things. The problem is, I
can't find it. If anyone out there can give me a heads up
on this, I would greatly appreciate it!!!
Thanks - Angela
 
C

Chip Pearson

Angela,

The easiest way to do this is to enter the formula

=CHAR(ROW())

in cell A1 and fill down to row 255. This will display the
characters associated with the corresponding Ascii code (which is
the row number). Then, to use a symbol, hold down the ALT key
and type the four digit (including leading zeros) on the numeric
keypad (not the number keys above the letters).


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
T

TK

Angela,

You can use the Windows Character Map utility to see what
symbols are supported in the font you are using, and this
can also be used to copy/paste the desired symbols into
Excel, or any other Windows application.

Unfortunately, the Character Map utility is not always
included when Windows is installed, so if you cannot find
it (usually under the Accessories\System Tools branch of
the Windows Start Menu), another option is to use an Alt-
keysroke combination that returns the desired code. For
instance, try the following codes (hold down the Alt key
while typing the numeric sequence):

Degree symbol "°" can be entered using Alt+0176
Trademark symbol "T" can be entered with Alt+0153
Registered symbol "®" can be entered with Alt+0174

There are lots of symbols, and having a reference of the
available symbols would be helpful. A search on Google
for "Alt symbol" produced a long list of hits, the first
of which was:

http://www.tedmontgomery.com/tutorial/ALTchrc.html

and this may help, but the easiest approach is the
Character Map, so I try that first.

HTH,

Tom
 
D

David McRitchie

You can install the CharMap on your Excel menu or toolbar
Symbols for HTML and Excel use
http://www.mvps.org/dmcritchie/rexx/htm/symbols.htm
note there is a table at the top for some of the keyboard
shortcuts for some of the characters.

For a table of characters, webdings, wingdings
this list will be dependent on your browser. If you are using
IE it should match what you see in Excel
Font Tables as Rendered by your browser
(fonts.htm -- CODE, Hex, CHAR, bold, symbol,
webdings, wingdings, wingdings 2, wingdings 3)
http://wwww.mvps.org/dmcritchie/rexx/htm/fonts.htm
If you are using Mozilla or Firefox as you browser you might
want to install the fonts you already have if using Excel.
http://wwww.mvps.org/dmcritchie/firefox/firefox.htm




--
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

Angela,

You can use the Windows Character Map utility to see what
symbols are supported in the font you are using, and this
can also be used to copy/paste the desired symbols into
Excel, or any other Windows application.

Unfortunately, the Character Map utility is not always
included when Windows is installed, so if you cannot find
it (usually under the Accessories\System Tools branch of
the Windows Start Menu), another option is to use an Alt-
keysroke combination that returns the desired code. For
instance, try the following codes (hold down the Alt key
while typing the numeric sequence):

Degree symbol "°" can be entered using Alt+0176
Trademark symbol "T" can be entered with Alt+0153
Registered symbol "®" can be entered with Alt+0174

There are lots of symbols, and having a reference of the
available symbols would be helpful. A search on Google
for "Alt symbol" produced a long list of hits, the first
of which was:

http://www.tedmontgomery.com/tutorial/ALTchrc.html

and this may help, but the easiest approach is the
Character Map, so I try that first.

HTH,

Tom
 
Top