How to Type ĵ (J with circumflex) on Excel
Typing ĵ (j with circumflex) on Excel takes a few seconds once you know the trick. The short answer is =UNICHAR(309). Read on for step-by-step instructions, the uppercase Ĵ and what to do when a method does not work.
ĵ on Excel: =UNICHAR(309)
Ĵ on Excel: =UNICHAR(308)
Or copy it:
Method 1: UNICHAR formula
Type =UNICHAR(309) in a cell to get ĵ. To check a letter, =UNICODE("ĵ") returns 309. 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 0135) on Windows or Unicode Hex Input (Option + 0135) on a Mac.
Method 3: Find and replace accented text
Use =SUBSTITUTE(A1,"ĵ","j") 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(308) in a cell to get Ĵ. To check a letter, =UNICODE("Ĵ") returns 308. 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 0134) on Windows or Unicode Hex Input (Option + 0134) on a Mac.
About the letter ĵ
ĵ is Unicode U+0135, named LATIN SMALL LETTER J WITH CIRCUMFLEX. It is used in Esperanto. A small caret (^) above a vowel. In French it often marks a vanished s (forêt from forest), in Portuguese a closed vowel, in Welsh a long vowel, and in Vietnamese a distinct vowel (â, ê, ô). 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(309).
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+0135. In HTML it is ĵ.
Related guides
- How to Type ĵ (J with circumflex) on Windows
- How to Type ĵ (J with circumflex) on Mac
- How to Type ĵ (J with circumflex) on iPhone
- How to Type ĵ (J with circumflex) on Android
- How to Type ĵ (J with circumflex) on Microsoft Word
- How to Type ĵ (J with circumflex) on Google Docs
- How to Type į (I with ogonek) on Excel
- How to Type ı (Dotless i) on Excel
- How to Type ķ (K with cedilla) on Excel
- How to Type ĺ (L with acute) on Excel