Results 1 to 7 of 7
  1. #1
    New Lounger
    Join Date
    Dec 2004
    Posts
    20
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Unicode Revisited (Excel 2003 (SP1))

    In Word 2003 one can enter a Unicode Value such as 00E6 then press Alt + x to produce the relevant character. This does not appear to work in Excel 2003 (SP1).
    Is this a broken feature, or is there a different way to enter Unicode in Excel?
    George Bell.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Unicode Revisited (Excel 2003 (SP1))

    The Alt+x method of entering Unicode characters is specific to Word, it is not implemented in Excel. Use Insert | Symbol... to insert Unicode characters into an Excel spreadsheet, or copy/paste them from the Character Map accessory.

  3. #3
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Unicode Revisited (Excel 2003 (SP1))

    For some characters at least, if you convert the Hex value to decimal, you can then enter Alt + nnnn. In your example, 00E6 = 230 so entering Alt+0230 will give you
    Regards,
    Rory

    Microsoft MVP - Excel

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Unicode Revisited (Excel 2003 (SP1))

    When entering characters using Alt+numeric keypad, Excel uses the (decimal) number modulo 256. Alt+65 and Alt+321 and Alt+2625 all result in "A". So you can only enter standard ANSI characters this way.

  5. #5
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Unicode Revisited (Excel 2003 (SP1))

    You might also look this <!post=thread,118507>thread<!/post>.
    -John ... I float in liquid gardens
    UTC -7ąDS

  6. #6
    New Lounger
    Join Date
    Dec 2004
    Posts
    20
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Unicode Revisited (Excel 2003 (SP1))

    Looks like it's broken then. According to Excel's Help, the Alt + X method should work. Clearly it doesn't. T

    To locate where is states this, go to Help, Search for "keyboard". Select "Keyboard Shortcuts". At the very foot of this topic, expand "Work with multiple national languages". Go to the end.

    ALT+X
    Pressed immediately after typing the hexadecimal code for a unicode character, converts the numbers to the character.
    Pressed immediately following a unicode character, converts the character to its hexadecimal code.

  7. #7
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Unicode Revisited (Excel 2003 (SP1))

    The same is mentioned in the online help for Excel 2002, where it doesn't work either. <img src=/S/crazy.gif border=0 alt=crazy width=15 height=15>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •