Inserting special characters

[Fred Newton]

I've seen the facility to insert bullets and other special characters
by use of the Alt key and then a code sequence, but is there a
documented list of these codes and characters/functions they perform
please.

Many thanks
Fred Newton
Zurich Financial Services

 

[Norman Harker]

Hi Fred!

Here's a source posted by Tom Ogilvy to a similar request:

http://www.deaneng.com/csi_wan/chart.html

See also:
http://qcpages.qc.edu/~nixon/links/asciiUnicode.html
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Bob Phillips]

Morning Fred,

Look here

http://www.xldynamic.com/xlDynamic.com - Using Excel - 001.html

or you could check Chips's page on special characters and download his
Symbolizer utility at http://www.cpearson.com/excel/chars.htm

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Peo Sjoblom]

You can create your own list, open a new workbook
in A1 put

=CHAR(ROW(1:1))

or

=CHAR(ROW())

the result would be the same if you put the formula in A1
otherwise the latter will return the row number of the cell that holds it.
Now copy down the formula to A255 (or 255 rows if you put it somewhere else
but row 1)
the row number will now be the code number

Alt + 65 on the numpad returns "A"

Alt + 149 returns a bullet


to get different characters you can format the list with wing dings


http://www.cpearson.com/excel/chars.htm

for more, Chip also has an add-in that can be installed for special
characters

 

[David McRitchie]

You will want to use different fonts in the columns, so you can see
the symbol you want. An example is in
Font Tables as Rendered by your browser
http://wwww.mvps.org/dmcritchie/rexx/htm/fonts.htm