How to Type ņ (N with cedilla) on Excel
Need ņ on Excel for a name, an address or a word in another language? You do not have to copy it from a website every time. The fastest method is =UNICHAR(326), and there are a few backups below for when that one is not available.
ņ on Excel: =UNICHAR(326)
Ņ on Excel: =UNICHAR(325)
Or copy it:
Method 1: UNICHAR formula
Type =UNICHAR(326) in a cell to get ņ. To check a letter, =UNICODE("ņ") returns 326. Both work in Excel 2013 and later and in Google Sheets.
Method 2: Keyboard methods inside a cell
Double-click the cell, then use Insert → Symbol (Unicode hex 0146) on Windows or Unicode Hex Input (Option + 0146) on a Mac.
Method 3: Find and replace accented text
Use =SUBSTITUTE(A1,"ņ","n") to strip this accent from a column, for example when cleaning names for an email system that does not accept accents.
How to type the capital Ņ
The uppercase form works the same way with Shift added where a letter is typed.
UNICHAR formula
Type =UNICHAR(325) in a cell to get Ņ. To check a letter, =UNICODE("Ņ") returns 325. Both work in Excel 2013 and later and in Google Sheets.
Keyboard methods inside a cell
Double-click the cell, then use Insert → Symbol (Unicode hex 0145) on Windows or Unicode Hex Input (Option + 0145) on a Mac.
About the letter ņ
ņ is Unicode U+0146, named LATIN SMALL LETTER N WITH CEDILLA. It is used in Latvian. A small hook under a letter. ç gives a soft s sound in French, Portuguese, Catalan, Turkish and Albanian; Turkish also uses ş, and Latvian uses ģ, ķ, ļ, ņ. See the ņ character page for every code and shortcut.
Troubleshooting
- UNICHAR is not available in Excel 2010 and earlier.
- CSV files saved as plain "CSV" may lose accents. Save as "CSV UTF-8".
- If accents show as question marks after import, set the file origin to 65001: Unicode (UTF-8) in the import wizard.
Frequently asked questions
What is the shortcut for ņ on Excel?
=UNICHAR(326).
Can I just copy and paste ņ?
Yes. Click the copy button above, then paste with Ctrl+V on Windows and Chromebook, Cmd+V on a Mac, or touch and hold and choose Paste on a phone.
What is the Unicode code for ņ?
U+0146. In HTML it is ņ.
Related guides
- How to Type ņ (N with cedilla) on Windows
- How to Type ņ (N with cedilla) on Mac
- How to Type ņ (N with cedilla) on iPhone
- How to Type ņ (N with cedilla) on Android
- How to Type ņ (N with cedilla) on Microsoft Word
- How to Type ņ (N with cedilla) on Google Docs
- How to Type ľ (L with caron) on Excel
- How to Type ł (L with stroke) on Excel
- How to Type ő (O with double acute) on Excel
- How to Type œ (Oe ligature (ethel)) on Excel