PHONETIC Function
Returns the phonetic (furigana) reading stored with Japanese text.
Category
Text
Available in
All versions, Microsoft 365
Returns
Text
Want to practice PHONETIC in a real spreadsheet? Open a blank sheet in our Practice Sandbox and try it with live data, with the AI Excel tutor beside you. No Excel needed — just a free account.Try it free in the Sandbox
Overview
When Japanese text is typed with a Japanese keyboard, Excel can store its pronunciation guide (furigana) alongside. PHONETIC returns that reading — useful for sorting names by sound.
If no reading is stored, PHONETIC simply returns the cell's text.
Syntax
=PHONETIC(reference) Explain
Arguments
| Argument | Required? | What it does |
|---|---|---|
| reference | Yes | A cell (or range — the top-left cell is used) containing the text. |
Examples
Example 1 — Reading a Japanese name
A2 holds 山田 typed with a Japanese keyboard.
=PHONETIC(A2) Explain
Returns ヤマダ (Yamada). Text pasted in from elsewhere has no stored reading, so you get 山田 back.
Common mistakes
- Only cell references. PHONETIC doesn't accept typed text like PHONETIC("山田") — the reading lives with the cell.
Notes

Author
Kyle Stott
Certified Microsoft Excel Expert
Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.