How to Type đ (D with stroke) on Excel
The letter đ does not have its own key on an English keyboard, but Excel still makes it easy to type. Use =UNICHAR(273), or pick one of the other methods in this guide. đ appears in Croatian and Vietnamese.
đ on Excel: =UNICHAR(273)
Đ on Excel: =UNICHAR(272)
Or copy it:
Method 1: UNICHAR formula
Type =UNICHAR(273) in a cell to get đ. To check a letter, =UNICODE("đ") returns 273. 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 0111) on Windows or Unicode Hex Input (Option + 0111) on a Mac.
Method 3: Find and replace accented text
Use =SUBSTITUTE(A1,"đ","d") 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(272) in a cell to get Đ. To check a letter, =UNICODE("Đ") returns 272. 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 0110) on Windows or Unicode Hex Input (Option + 0110) on a Mac.
About the letter đ
đ is Unicode U+0111, named LATIN SMALL LETTER D WITH STROKE. It is used in Croatian and Vietnamese. A line through the letter itself. Examples are ø (Danish, Norwegian), ł (Polish), đ (Vietnamese, Croatian) and ħ (Maltese). 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(273).
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+0111. In HTML it is đ.
Related guides
- How to Type đ (D with stroke) on Windows
- How to Type đ (D with stroke) on Mac
- How to Type đ (D with stroke) on iPhone
- How to Type đ (D with stroke) on Android
- How to Type đ (D with stroke) on Microsoft Word
- How to Type đ (D with stroke) on Google Docs
- How to Type ć (C with acute) on Excel
- How to Type ď (D with caron) on Excel
- How to Type ę (E with ogonek) on Excel
- How to Type ě (E with caron) on Excel