setting special character shortcut keys?

B

Brian

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
 
B

Brian

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
 
G

Gord Dibben

Alt + 225 on the NumPad

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


Gord Dibben MS Excel MVP
 
B

Brian

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
 
D

Dave Peterson

Maybe you could cheat:

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