How to Type ċ (C with dot above) on Excel
Typing ċ (c with dot above) on Excel takes a few seconds once you know the trick. The short answer is =UNICHAR(267). Read on for step-by-step instructions, the uppercase Ċ and what to do when a method does not work.
ċ on Excel: =UNICHAR(267)
Ċ on Excel: =UNICHAR(266)
Or copy it:
Method 1: UNICHAR formula
Type =UNICHAR(267) in a cell to get ċ. To check a letter, =UNICODE("ċ") returns 267. 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 010B) on Windows or Unicode Hex Input (Option + 010B) on a Mac.
Method 3: Find and replace accented text
Use =SUBSTITUTE(A1,"ċ","c") 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(266) in a cell to get Ċ. To check a letter, =UNICODE("Ċ") returns 266. 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 010A) on Windows or Unicode Hex Input (Option + 010A) on a Mac.
About the letter ċ
ċ is Unicode U+010B, named LATIN SMALL LETTER C WITH DOT ABOVE. It is used in Maltese. A single dot above a letter, used in Polish (ż), Lithuanian (ė), Maltese (ċ, ġ, ż) and Turkish (İ, the dotted capital I). 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(267).
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+010B. In HTML it is ċ.
Related guides
- How to Type ċ (C with dot above) on Windows
- How to Type ċ (C with dot above) on Mac
- How to Type ċ (C with dot above) on iPhone
- How to Type ċ (C with dot above) on Android
- How to Type ċ (C with dot above) on Microsoft Word
- How to Type ċ (C with dot above) on Google Docs
- How to Type ż (Z with dot above) on Excel
- How to Type ĉ (C with circumflex) on Excel
- How to Type ė (E with dot above) on Excel
- How to Type ĝ (G with circumflex) on Excel