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"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top