setting special character shortcut keys?

[Guest]

Is it possible to set a shortcut key to display special characters?

In word you can assign say ctrl>a to give you á (done from the insert symbol
option) is this possible in Excel?

Thanks

 

[Guest]

I believe I found teh answer:

have to go to the character map to get the code then use 'alt 0225' for
example.

If there is an easier way like in word, please let me know

Thanks

 

[Gord Dibben]

Alt + 225 on the NumPad

See the Insert>Symbol>Character Code>Ascii Decimal for the code numbers.


Gord Dibben MS Excel MVP

 

[Guest]

scratch that...

that answer works if you have a separate number pad - what do I do on a
laptop with no number pad (just the single row of numbers)?

thanks

 

[Gord Dibben]

Usually pressing the Fn key will put you in NumPad mode.


Gord

 

[Dave Peterson]

Maybe you could cheat:

=char(225)
or
="this is text " & char(225) & " and more text"