Formula to display character output of alt + (####)

[brharrii]

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

[Moo the Dog]

Try this... If your list of numbers starts in A1, put this in B1 and fill down:

Please Login or Register  to view this content.

The problem I see with this is that Alt + 248 (°) is different than Alt + 0248 (ø)... so not sure where to go from there.
- Moo

[Tony Valko]

Try this... If your list of numbers starts in A1, put this in B1 and fill down:

=UNICHAR(A1)

That function is only available in PC Excel 2013.

[Moo the Dog]

That function is only available in PC Excel 2013.

Thanks, Tony. Now I know, for future info.

- Moo

[Tony Valko]

Do you have it in one of your Mac versions? Mac Office 2011?

[Moo the Dog]

Tony,

Forgot to change my profile, I use Office 2007/2013 for PC and 2011 for Mac now. Been using 2013 tonight. I'll have to check to see if it is available on the Mac at work tomorrow.

- Moo

[brharrii]

Hey Moo,

Yeah as suggested by Tony, that didn't work on my 2010 version. Any other suggestions?

Thanks again!