How to Type õ (O with tilde) on Excel

Q: What is the Unicode code for õ?

U+00F5. In HTML it is &otilde;.

Published August 6, 2026, 2 min read

õ is o with tilde, a letter used in Portuguese, Estonian and Vietnamese. On Excel, the quickest way to get it is =UNICHAR(245). This guide covers every method that works, including the capital Õ and fixes for common problems.

õ on Excel: =UNICHAR(245)

Õ on Excel: =UNICHAR(213)

Or copy it:

Method 1: UNICHAR formula

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

Method 2: CHAR formula on Windows

=CHAR(245) 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+0245 on Windows or Option+N, 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(213) in a cell to get Õ. To check a letter, =UNICODE("Õ") returns 213. Both work in Excel 2013 and later and in Google Sheets.

CHAR formula on Windows

=CHAR(213) 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+00F5, named LATIN SMALL LETTER O WITH TILDE. It is used in Portuguese, Estonian and Vietnamese. A wavy line above a letter. Spanish uses it for ñ, Portuguese for nasal vowels (ã, õ), Estonian for õ, and Vietnamese for the broken rising 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(245).

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+00F5. In HTML it is õ.

Related guides

All accent shortcuts for Excel