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

ArgumentRequired?What it does
referenceYesA 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

Kyle Stott

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.