Text

PHONETIC Function in Excel

Extracts the phonetic (furigana) characters from a text string.

Syntax

  • =PHONETIC(reference)

Arguments

  • reference (required): Cell with phonetic text

Examples

  • =PHONETIC(A1) - Extract furigana - Result: Phonetic text

Excel PHONETIC function documentation

  • PHONETIC extracts phonetic (furigana) text from a cell that includes phonetic data.
  • Syntax: =PHONETIC(reference). Often used in Japanese-language worksheets.
  • Use PHONETIC to expose pronunciation text for sorting, labels, or export fields.
  • Text function category: [/categories/text/](/categories/text/).

PHONETIC syntax and data requirements

  • reference must point to a cell containing phonetic information, not plain text only.
  • If phonetic metadata is missing, PHONETIC can return blank or limited output.
  • Behavior depends on source text input method and workbook language setup.
  • Keep original text and phonetic output together for QA before publishing.

Step-by-step: build pronunciation helper column

  • Step 1 - Keep original Japanese text in column A.
  • Step 2 - In B2 use =PHONETIC(A2).
  • Step 3 - Copy down and review blanks where phonetic data is absent.
  • Step 4 - Use B column for pronunciation-aware sorting workflows.

PHONETIC vs direct text vs custom transliteration

  • PHONETIC reads existing furigana metadata and avoids manual retyping.
  • Direct text extraction cannot guarantee pronunciation correctness.
  • Custom transliteration rules can be complex and less trustworthy for names.
  • Style output labels with [TEXT](/functions/text/) only when needed.

Worked examples to copy

  • Basic extraction: =PHONETIC(A2).
  • Fallback label: =IF(PHONETIC(A2)="","No phonetic",PHONETIC(A2)).
  • Normalized helper: =TRIM(PHONETIC(A2)).
  • Sort key pattern: =UPPER(PHONETIC(A2)).

People also ask

  • Why does PHONETIC return blank? - The source cell likely has no phonetic metadata.
  • Can PHONETIC generate pronunciation automatically? - It reads stored phonetic data, not full AI transliteration.
  • PHONETIC useful for exports? - Yes, especially when external systems require reading keys.
  • Is PHONETIC available everywhere? - It is best supported in language setups that store furigana.

Common errors

  • Returns empty if no phonetic info

Use cases

  • Japanese text
  • Pronunciation
  • Sorting

Frequently asked questions

  • What is PHONETIC used for in Excel? PHONETIC extracts furigana (phonetic reading guides) from Japanese text. In Japanese Excel, kanji characters can have associated hiragana/katakana readings stored as phonetic info. PHONETIC retrieves this hidden pronunciation data.
  • Why does PHONETIC return empty? PHONETIC only works if phonetic information was entered with the text. In Japanese Excel, you can add furigana via Format > Phonetic Guide. Text typed without phonetic info, or in non-Japanese Excel versions, has no phonetic data to extract.
  • Can PHONETIC work with non-Japanese text? PHONETIC is designed for Japanese furigana. For other languages, it typically returns empty or the original text. It's a specialized function for Japanese language processing in Excel.

Editorial review

  • Reviewed by Excel.Directory Editorial Team. Updated May 2026.

When to use PHONETIC

  • Japanese text — common Text scenario for PHONETIC.
  • Pronunciation — common Text scenario for PHONETIC.
  • Sorting — common Text scenario for PHONETIC.

PHONETIC in the Text category

  • Browse all Text functions at /categories/text/ for related formulas.
  • PHONETIC syntax: =PHONETIC(reference)
  • reference (required): Cell with phonetic text
  • Confirm PHONETIC arguments match the syntax shown above before filling down.
  • Lock table and range references with $ when copying formulas across rows or sheets.

Formula checklist before you copy down

  • Confirm PHONETIC arguments match the syntax shown above before filling down.
  • Lock table and range references with $ when copying formulas across rows or sheets.
  • If results look wrong, check for text stored as numbers and invisible spaces with TRIM.
  • Spot-check three known input rows manually against expected output.

Related Excel functions

  • ASC (/functions/asc/): Changes full-width (double-byte) characters to half-width (single-byte) characters.
  • JIS (/functions/jis/): Changes half-width (single-byte) characters to full-width (double-byte) characters.
  • TEXT (/functions/text-function/): Converts a value to text in a specified number format.

Errors to watch for

  • Returns empty if no phonetic info — review causes on linked error pages in the directory.

Copy-paste audit workflow

  • Enter PHONETIC on three test rows with known expected output documented on a QA tab.
  • Fill down only after absolute references are locked on lookup tables and rate tables.
  • Compare against manual calculation or a calculator for financial and statistical functions.
  • Search this directory for comparison guides when choosing between similar functions in the same category.

PHONETIC worked examples to copy

  • =PHONETIC(A1) — Extract furigana. Expected result: Phonetic text.

PHONETIC reference summary for crawlers and offline review

  • PHONETIC belongs to the Text category in Excel. Extracts the phonetic (furigana) characters from a text string.
  • Full syntax: =PHONETIC(reference). Open /functions/phonetic/ for parameters, FAQs, and related pages.
  • Common mistakes: Returns empty if no phonetic info
  • Pair this function with comparison guides when another Excel formula might fit the same task better.
  • Review fix-excel-formula-errors when unexpected errors appear after upgrading Excel or sharing across locales.