View Single Post
  #2   Report Post  
Nick Hodge
 
Posts: n/a
Default

Lindsay

Still available, using Alt+[number] from the numeric keypad. I use the
symbol viewer via StartAccessoriesSystem Tools and look in the corner
after selecting the character, but you could do it this way.

Enter a 1 in cell A1 and copy a series down to Cell A256 so you have 1-256
in column A. Now in B1 enter =CHAR(A1) and copy down. You should get the
characters in the cells now. (0-32 are control characters and show as
squares)

Now if you hold the Alt key down and type on the numeric keypad 0 and then
the number next to the character you want and release both keys together you
should find it shows the character.

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"Lindsay" wrote in message
...
In previous versions of Excel there were ALT + functions that allowed the
insertion of symbols using only the keyboard rather than a dropdown box.
Does anyone know if these are still in place and if so, how I might get a
listing of the necessary numbers, etc. to make use of these?