PHONETIC Function in Microsoft Excel: Syntax, Examples & Troubleshooting

=PHONETIC(reference)

Reference is required. Microsoft describes a text string or a reference to a cell or range containing furigana text. There is no argument for a target language, pronunciation dictionary or romanization style. Use a cell reference when you need to preserve and inspect the stored reading.

The function’s reference requires a Far East region setting, identifying Japanese, Chinese and Korean. A system’s ability to display Japanese characters alone does not establish that the required phonetic metadata is present.

For a contiguous range, the result comes from its upper-left cell, rather than combining all readings in the range. For a range of nonadjacent cells, Microsoft documents #N/A.

Microsoft’s furigana setup and editing guide, checked October 17, 2026, explains that new data entered in the Japanese version of Excel can receive phonetic information. Opening older files or files created in another program does not automatically generate that information.

In a suitable Japanese-enabled desktop environment, prepare these cells and inspect or edit their phonetic fields through the Home tab’s phonetic controls:

Use the documented Show Phonetic Fields and Edit controls to verify the readings. Interface labels and availability depend on the platform and language setup. The table specifies both text and metadata; simply pasting the visible characters into C4 and B7 is not a complete setup.

No regional setting was changed and no workbook was opened in Excel to prepare this guide. These are explicit setup instructions for the documented example, not claims of a locally created native fixture.

1. Verify that C4 contains 東京都 with the stored reading トウキョウト.
2. In D4, enter =PHONETIC(C4).
3. The documentation-reported expected text is トウキョウト.

The expected reading is taken from Microsoft’s illustrated example, whose Japanese characters are embedded in images. It is conditional on the stated metadata. A different stored reading is a different input even when the visible kanji text looks identical.

With B7 containing 大阪府 and the stored reading オオサカフ, =PHONETIC(B7) has the documentation-reported expected result オオサカフ.

If D7 contains that extracted text, =EXACT(D7,"オオサカフ") is independently expected to return TRUE. This checks the returned text against an approved reading; it does not certify that the pronunciation is correct for every name or context.

For a Japanese address or name list, keep the original text, stored phonetic reading and a reviewer-approved reading available separately. Copy a single-cell PHONETIC reference down the list to extract one reading at a time. Do not use one large range expecting it to concatenate every row.

For example, if C4 retains the prepared Tokyo metadata, =PHONETIC(C4:D5) is expected to return トウキョウト, because C4 is the upper-left cell. The contents of D4, C5 and D5 do not turn this formula into a multi-cell extraction.

For a nonadjacent-range check, a defined name that refers to C4 and B7 as separate areas is not equivalent to the contiguous rectangle C4:D5. Passing that nonadjacent reference to PHONETIC is documented to return #N/A. Use separate single-cell formulas instead.

If no reading appears as expected, first inspect whether the cell actually contains furigana information. Imported text and copy/paste workflows may not provide it. Do not interpret missing metadata as evidence that the Japanese characters have no pronunciation.

Microsoft’s setup guide distinguishes web viewing from editing. In Excel for the web, furigana display depends on host/language/region settings; the guide says editing the reading requires Excel for Windows. If the cell has no furigana information, the web Show/Hide control is disabled. The desktop/Mac portions also describe phonetic display and editing controls; do not assume every web limitation applies to every desktop build.

Furigana can be displayed in hiragana or full-/half-width katakana styles. Keep the stored and displayed reading assumptions explicit when comparing exact text. PHONETIC is neither a translation function nor a universal conversion from kanji to romaji, and these examples make no native-execution claim.

Microsoft’s reference checked on October 17, 2026 lists: Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel 2024 Excel 2024 for Mac Excel 2021 Excel 2021 for Mac Excel 2019 Excel 2016. This current support list does not establish the first release. The introduction version and last functioning version have not been established from the reviewed documentation. No retirement is asserted.

Example verification: Phonetic outputs are documentation-reported and conditional on the stated stored reading metadata; the EXACT comparison follows independently from those strings. These examples have not been tested in Microsoft Excel. No screenshot or native execution is claimed.

EXACT in Excel | IF in Excel | LEN in Excel | CONCAT in Excel

• Microsoft PHONETIC reference, retrieved October 17, 2026.