In excel if you hold the alt button and push "2 4 8" consecutively, excel will create a degree sign "°" .
I'm wondering if it is possible to create a formula that will let me reference an adjacent cell to create a list of symbols and their numerical equivilants. Column A would be a list of numbers 1-99999 for example and then column b would have a formula that looks something to the extent of:
= Alt + Column A
To display the the symbol that will be output if the number in column A is entered while holding alt. I am familiar with the Insert -> symbol menu and know there are other ways to go about this, I was hoping that there might be an easy way to generate a list like this without going into the symbol menu though.
Thanks!
Bruce
Bookmarks