Accenting letters in Excel

[Guest]

How do I accent the letter "e" with ` or ' in Excel?

 

[Ragdyer]

You can use Char() entries.

Hold down <Alt>, and use the numbers from the NUM keypad, *not* the numbers
under the function keys:

<Alt>0200 = È
<Alt>0201 = É
<Alt>0232 = è
<Alt>0233 = é

 

[Guest]

Alt + 138 (using the number keypad)

or the formula =CHAR(232), which you can concatenate like

="This is an example: "&CHAR(232)

 

[Guest]

Definitely helped! Thank you RD!

Burric

You can use Char() entries.

Hold down <Alt>, and use the numbers from the NUM keypad, *not* the numbers
under the function keys:

<Alt>0200 = È
<Alt>0201 = É
<Alt>0232 = è
<Alt>0233 = é

 

[Guest]

For me, Alt 232 returns this: Φ
and Alt 138 returns: è

If your machine returns different characters, do you have any ideas what the
difference is?
Thanks!

 

[Ragdyer]

I get *exactly* what you get, using your numbers.

BUT ... my suggestions include *4* digits.
I didn't add leading 0's because I like to type!<bg>

Try it, you might like it.<g>

 

[Guest]

I just figured that's what I get for getting a cheap keyboard. Thanks for
pointing me in the right direction.

 

[Guest]

Another method I have used is to paste it in from Word, which is slower than
the Alt+ options but OK if you forget which characters to use and you are use
to doing it in Word.

 

[raypayette]

People, you missed the obvious!
Click Insert, Symbol and choose the character.

 

[Guest]

Can't find that on my machine (and don't remember ever seeing it). I've got
XL2000, which version are you using?

He could also use paste it in from the character map, which I see also tells
you what keystroke to use (which is a feature I never really noticed before
now - 0232 as Ragdyer posted).

 

[Gord Dibben]

JMB

Insert>Symbol was introduced with 2002 version.


Gord Dibben MS Excel MVP

Can't find that on my machine (and don't remember ever seeing it). I've got
XL2000, which version are you using?

He could also use paste it in from the character map, which I see also tells
you what keystroke to use (which is a feature I never really noticed before
now - 0232 as Ragdyer posted).

 

[Guest]

Thanks for clearing that up.

JMB

Insert>Symbol was introduced with 2002 version.


Gord Dibben MS Excel MVP

Can't find that on my machine (and don't remember ever seeing it). I've got
XL2000, which version are you using?

He could also use paste it in from the character map, which I see also tells
you what keystroke to use (which is a feature I never really noticed before
now - 0232 as Ragdyer posted).

 

[Guest]

All of this is very true, but I do lean with RagDyer on this one. If it's
only a once-a-year usage, insert symbol would work. However, if you use it
more frequently, you can click out the Alt#### sequences a lot faster. That
was the useful part of co-lab training as a Spanish major... Alt-0224, 0233,
0237, 0241, 0243, 0250, etc.
-MikeDH

 

[Bine_NZ]

Hi all!

Somehow, holding Alt and typing the numbers from my numpad doesn't work for
me. I just get numbers. Is there a difference when using a mac keyboard? I
noticed that I don't have a num key and my alt key is mainly called option
(with alt only in tiny superscript).

I'm also confused because I've got excel 2004, which from your description
should have the symbol menu included, but it doesn't.

Could you please help me how to quickly insert lots of different symbols
(pasting from word is just such a pain and also makes other parts of the same
cell show up in Greek as well).

Cheers,

 

[Fred Smith]

If you have a Mac, you'll likely have more success posting to the Mac group
rather than the PC group. Try: microsoft.public.excel.macintosh.

Regards,
Fred.