How to Type á (A with acute) on Excel
Typing á (a with acute) on Excel takes a few seconds once you know the trick. The short answer is =UNICHAR(225). Read on for step-by-step instructions, the uppercase Á and what to do when a method does not work.
á on Excel: =UNICHAR(225)
Á on Excel: =UNICHAR(193)
Or copy it:
Method 1: UNICHAR formula
Type =UNICHAR(225) in a cell to get á. To check a letter, =UNICODE("á") returns 225. Both work in Excel 2013 and later and in Google Sheets.
Method 2: CHAR formula on Windows
=CHAR(225) also returns á on Windows, because it uses the Windows-1252 code page. On a Mac CHAR uses a different code page, so prefer UNICHAR.
Method 3: Keyboard methods inside a cell
Double-click the cell, then use Alt+0225 on Windows or Option+E, then A on a Mac.
Method 4: 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(193) in a cell to get Á. To check a letter, =UNICODE("Á") returns 193. Both work in Excel 2013 and later and in Google Sheets.
CHAR formula on Windows
=CHAR(193) also returns Á on Windows, because it uses the Windows-1252 code page. On a Mac CHAR uses a different code page, so prefer UNICHAR.
About the letter á
á is Unicode U+00E1, named LATIN SMALL LETTER A WITH ACUTE. It is used in Spanish, Portuguese, Czech, Slovak, Hungarian, Icelandic, Dutch and Welsh. A short line slanting up to the right. It marks stress in Spanish (canción), a closed vowel in French (été), vowel length in Czech, Hungarian and Irish, and a rising tone in Vietnamese and Pinyin. 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(225).
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+00E1. In HTML it is á.
Related guides
- How to Type á (A with acute) on Windows
- How to Type á (A with acute) on Mac
- How to Type á (A with acute) on iPhone
- How to Type á (A with acute) on Android
- How to Type á (A with acute) on Microsoft Word
- How to Type á (A with acute) on Google Docs
- How to Type í (I with acute) on Excel
- How to Type ú (U with acute) on Excel
- How to Type ü (U with umlaut) on Excel
- How to Type à (A with grave) on Excel