How to add any unicode character in excel through shortcut?

[Coaster]

Hi,

I know U+2074 is the code for a superscript 4, but how do I insert this in excel? Alt + 2074 won't give me that symbol....

BTW, why is that when I type ALT + 55123123 (random number) i get a symbol, in this case a | ? Where is the correspondence between that number and that symbol? Knowing that table could solve my problem..

[brokenbiscuits]

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

The 'Creating A List Of Symbols' section is particularly helpful.

[Coaster]

thank you for your answer but that only gives me the ascii list, and the ascii list doesn't include a superscript 4 (or any other number other than 1,2 or 3)

I needed a table for the unicode list. Again, i've seen this unicode list and i know that the code that I want is U+2074 but i don't know how to type this into excel...

in word I can do it -> typing 2074 and then Alt+X...but in excel?

[brokenbiscuits]

The following link may help:

http://www.pcreview.co.uk/forums/uni...l-t941736.html

'The key to a solution may be the creation of a User-Defined Function CharW
with the following content:

Function CharW(dec As Long) As String
CharW = ChrW(dec)
End Function

Then if you have, for example, 20049 in cell A1, you can produce the
equivalent character with the formula =CharW(A1).'

[Coaster]

Thanks...that did help...

As far as i've worked out, I can only introduce unicode symbols if I enable hexadecimal input through the registry. Then, i can input: Alt + +2074 (i do have to input the "+" sign) and then i get the unicode symbol.

What is really bugging me is what symbol is created when using Alt + XXXX (without activating hexadecimal input) when XXXX is bigger than 255?

Between 0 and 255 I understand that Alt + XXXX is introducing an ASCII symbol, but for numbers higher than that what really happens?

[manohar2776]

I LIKED IT, IT SOLVED MY PROBLEM BUT THE QUESTION THAT WE COULD NOT ENTER THE UNICODE CHARACTER INTO EXCEL BY KEYBOARD IS NOT SOLVED, THE COMBINATION OF NUMBER, ALT, X DIDN'T WORKED IN EXCEL 2007. PLEASE SOLVE THIS ANYBODY.

[manohar2776]

I liked it, it solved my problem but the question that we could not enter the unicode character into excel by keyboard is not solved, the combination of number, alt, x didn't worked in excel 2007. Please solve this anybody.

[protonLeah]

manohar2776,
Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.