Problem with symbols

  • Thread starter Thread starter Jake
  • Start date Start date
J

Jake

Hello,

I'm trying to create some shortcuts to enter Greek letters into cells
in Excel. The =CHAR() works for most characters, but the unicode/hex
for the Greek letters is 03BB (lambda, for example) but nothing
recognizes the alpha characters. If I go to the symbol font I can enter
l for lambda, but I'd like something fast and easy, and not have to go
to the mouse to change fonts. I tried a macro that changes fonts, but
it doesn't work while typing in a cell...it changes it, and then
everything that then gets typed into the cell is that font. That isn't
normally what I want.

An add-in would work as well, but I haven't found one. Any ideas?
Thanks.

Steven
 
see
Unicode, Working with in Excel
http://www.mvps.org/dmcritchie/rexx/htm/unicode.htm
create CharW macro User Defined Function

For help installing a macro or userdefined function (UDF) see
http://www.mvps.org/dmcritchie/excel/getstarted.htm

=personal.xls!CharW(955) decimal equivalent of hex 03BB

lambda is 6C in the Symbol font, decimal 108
enter as Alt+0108 (in the symbol font)

I have charmap within my menus, see
http://www.mvps.org/dmcritchie/rexx/htm/symbols.htm#charmap
but if you want an addon see Chip Pearson's symbolizer
http://www.cpearson.com/excel/chars.htm
 
Back
Top