Practice free

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.

FormulaExcel showsCase
=PHONETIC(Items!B2) #N/A Cell with no furigana
=PHONETIC(Items!B2:B3) #N/A Range

The Items sheet these formulas read

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 .