How to Type ò (O with grave) on Excel

Q: What is the Unicode code for ò?

U+00F2. In HTML it is &ograve;.

Published August 15, 2026, 2 min read

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(242), and there are a few backups below for when that one is not available.

ò on Excel: =UNICHAR(242)

Ò on Excel: =UNICHAR(210)

Or copy it:

Method 1: UNICHAR formula

Type =UNICHAR(242) in a cell to get ò. To check a letter, =UNICODE("ò") returns 242. Both work in Excel 2013 and later and in Google Sheets.

Method 2: CHAR formula on Windows

=CHAR(242) 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+0242 on Windows or Option+`, then O on a Mac.

Method 4: Find and replace accented text

Use =SUBSTITUTE(A1,"ò","o") 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(210) in a cell to get Ò. To check a letter, =UNICODE("Ò") returns 210. Both work in Excel 2013 and later and in Google Sheets.

CHAR formula on Windows

=CHAR(210) 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+00F2, named LATIN SMALL LETTER O WITH GRAVE. It is used in Italian, Catalan, Vietnamese, Mandarin Pinyin and Yoruba. A short line slanting down to the right. French uses it on à, è and ù, Italian on final stressed vowels (città), Catalan and Portuguese for vowel quality, and Vietnamese and Pinyin for a falling tone. 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(242).

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+00F2. In HTML it is ò.

Related guides

All accent shortcuts for Excel