ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how do I type a tilde over the letter "n" in Excel? (https://www.excelbanter.com/excel-discussion-misc-queries/36453-how-do-i-type-tilde-over-letter-%22n%22-excel.html)

JobSeeker

how do I type a tilde over the letter "n" in Excel?
 
I am typing in Spanish.

I want to type, e.g., "nino" and "bebe" with a tilde over the letter "n" and
an acute accent over the letter "e".

I can type a tilde in Word (sometimes -- it usually does not work) by
pressing down simultaneously: CTRL + SHIFT + ~ (TILDE), then letting go of
those keys, and then pressing a lower-case "n".

I can type an acute accent in Word by pressing down simultaneously: CTRL +
Apostrophe, then letting go of those keys, and then presseing a lower-case
"e".

These shortcut combinations do not seem to be working in *Excel*.

I can also (in both Word and Excel) use Insert = Symbol = Symbol tab, and
then select the symbol I want, but this is very slow.

I prefer to use a shortcut key, rather than insert a symbol, because the
shortcut key method is much quicker.

Can anyone help me out?

Thank you in advance.

N Harkawat

=char(241)
will give you a n with a tilde

"JobSeeker" wrote in message
...
I am typing in Spanish.

I want to type, e.g., "nino" and "bebe" with a tilde over the letter "n"
and
an acute accent over the letter "e".

I can type a tilde in Word (sometimes -- it usually does not work) by
pressing down simultaneously: CTRL + SHIFT + ~ (TILDE), then letting go of
those keys, and then pressing a lower-case "n".

I can type an acute accent in Word by pressing down simultaneously: CTRL +
Apostrophe, then letting go of those keys, and then presseing a lower-case
"e".

These shortcut combinations do not seem to be working in *Excel*.

I can also (in both Word and Excel) use Insert = Symbol = Symbol tab,
and
then select the symbol I want, but this is very slow.

I prefer to use a shortcut key, rather than insert a symbol, because the
shortcut key method is much quicker.

Can anyone help me out?

Thank you in advance.




Connie Martin

Not sure if your Windows system works the same, but try this: press the ALT
key and type 164 from the number keypad. Here are some mo

ALT+130 = é
ALT+138 = è
ALT+136 = ê
ALT+139 = ï
ALT+140 = î
ALT+165 = Ñ

etc., etc., etc.! For a complete list go to:

http://teachers.sduhsd.k12.ca.us/abr...sh%20Codes.pdf
OR http://www.tedmontgomery.com/tutorial/ALTchrc.html
OR http://lladmin.truman.edu/accents.htm
OR http://www.cotse.com/altcodes.html

Many more places than these, too.

Connie



"JobSeeker" wrote:

I am typing in Spanish.

I want to type, e.g., "nino" and "bebe" with a tilde over the letter "n" and
an acute accent over the letter "e".

I can type a tilde in Word (sometimes -- it usually does not work) by
pressing down simultaneously: CTRL + SHIFT + ~ (TILDE), then letting go of
those keys, and then pressing a lower-case "n".

I can type an acute accent in Word by pressing down simultaneously: CTRL +
Apostrophe, then letting go of those keys, and then presseing a lower-case
"e".

These shortcut combinations do not seem to be working in *Excel*.

I can also (in both Word and Excel) use Insert = Symbol = Symbol tab, and
then select the symbol I want, but this is very slow.

I prefer to use a shortcut key, rather than insert a symbol, because the
shortcut key method is much quicker.

Can anyone help me out?

Thank you in advance.



All times are GMT +1. The time now is 10:13 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com