How to Type ą (A with ogonek) on Excel
Typing ą (a with ogonek) on Excel takes a few seconds once you know the trick. The short answer is =UNICHAR(261). Read on for step-by-step instructions, the uppercase Ą and what to do when a method does not work.
ą on Excel: =UNICHAR(261)
Ą on Excel: =UNICHAR(260)
Or copy it:
Method 1: UNICHAR formula
Type =UNICHAR(261) in a cell to get ą. To check a letter, =UNICODE("ą") returns 261. 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 0105) on Windows or Unicode Hex Input (Option + 0105) on a Mac.
Method 3: Find and replace accented text
Use =SUBSTITUTE(A1,"ą","a") 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(260) in a cell to get Ą. To check a letter, =UNICODE("Ą") returns 260. 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 0104) on Windows or Unicode Hex Input (Option + 0104) on a Mac.
About the letter ą
ą is Unicode U+0105, named LATIN SMALL LETTER A WITH OGONEK. It is used in Polish and Lithuanian. A small tail at the bottom right of a vowel, meaning “little tail” in Polish. It marks nasal vowels in Polish (ą, ę) and appears in Lithuanian (į, ų). 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(261).
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+0105. In HTML it is ą.
Related guides
- How to Type ą (A with ogonek) on Windows
- How to Type ą (A with ogonek) on Mac
- How to Type ą (A with ogonek) on iPhone
- How to Type ą (A with ogonek) on Android
- How to Type ą (A with ogonek) on Microsoft Word
- How to Type ą (A with ogonek) on Google Docs
- How to Type ō (O with macron) on Excel
- How to Type ă (A with breve) on Excel
- How to Type ć (C with acute) on Excel
- How to Type ď (D with caron) on Excel