How to Type ř (R with caron) on Excel
ř is r with caron, a letter used in Czech. On Excel, the quickest way to get it is =UNICHAR(345). This guide covers every method that works, including the capital Ř and fixes for common problems.
ř on Excel: =UNICHAR(345)
Ř on Excel: =UNICHAR(344)
Or copy it:
Method 1: UNICHAR formula
Type =UNICHAR(345) in a cell to get ř. To check a letter, =UNICODE("ř") returns 345. 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 0159) on Windows or Unicode Hex Input (Option + 0159) on a Mac.
Method 3: Find and replace accented text
Use =SUBSTITUTE(A1,"ř","r") 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(344) in a cell to get Ř. To check a letter, =UNICODE("Ř") returns 344. 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 0158) on Windows or Unicode Hex Input (Option + 0158) on a Mac.
About the letter ř
ř is Unicode U+0159, named LATIN SMALL LETTER R WITH CARON. It is used in Czech. A small v above a letter, called háček in Czech and kvačica in Croatian. It softens consonants (č, š, ž, ř) and marks the third tone in 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(345).
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+0159. In HTML it is ř.
Related guides
- How to Type ř (R with caron) on Windows
- How to Type ř (R with caron) on Mac
- How to Type ř (R with caron) on iPhone
- How to Type ř (R with caron) on Android
- How to Type ř (R with caron) on Microsoft Word
- How to Type ř (R with caron) on Google Docs
- How to Type œ (Oe ligature (ethel)) on Excel
- How to Type ŕ (R with acute) on Excel
- How to Type ś (S with acute) on Excel
- How to Type ŝ (S with circumflex) on Excel