PHONETIC function
PHONETIC returns the phonetic reading (furigana) attached to Japanese text in a cell. In other language setups it just returns the text itself, so it is rarely useful there.
Example
=PHONETIC(A1)
Expected result: n/a Not yet checked in desktop Excel
Syntax
PHONETIC(reference)
-
reference(required) - A cell or range containing text.
Returns: The phonetic (furigana) text for the cell.
What Excel actually returns
Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.
| Formula | Excel shows | Case |
|---|---|---|
=PHONETIC(Items!B2) | #N/A | Cell with no furigana |
=PHONETIC(Items!B2:B3) | #N/A | Range |
The Items sheet these formulas read
B
1
Item
2
Boxer cartridge
3
Briar pipe
Items
Watch out for
- Takes a reference, not typed text.
- Only meaningful with East Asian input.
Where it works
- Excel
- PHONETIC is in every version of Excel from 2007 on. Meaningful only with East Asian (Japanese) text; elsewhere returns the cell text.
- Google Sheets
- No direct equivalent. No counterpart.
Part of Text functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .