PHONETIC function

The PHONETIC function in Excel is used to extract the phonetic (or furigana) characters from text in a cell. Phonetic characters are used in languages like Japanese to display pronunciation guides above or alongside kanji characters. This function can be particularly useful when working with text that contains furigana (small kana characters) or similar phonetic annotations.

Syntax:

=PHONETIC(reference)

Parameters:

• reference (required): A reference to the cell containing the text from which you want to extract the phonetic characters.

Key Points:

• Furigana (Phonetic Characters): In Japanese, furigana are small kana characters (hiragana or katakana) used to show the pronunciation of kanji characters. The PHONETIC function helps extract these characters if they exist in the specified text.
• Text Extraction: This function will only work correctly if the text in the referenced cell contains phonetic annotations, like furigana, typically inserted using Excel’s Japanese IME (Input Method Editor).
• Return Value: If phonetic characters are present, the function returns the phonetic text. If no phonetic characters are found, it returns an empty string ("").

Example Usage:

1. Extracting Phonetic Text from a Cell

If cell A1 contains the text “漢字（かんじ）”, where “漢字” is the kanji and “かんじ” is the furigana, the formula:

=PHONETIC(A1)

This will return:

かんじ

The PHONETIC function extracts the furigana pronunciation “かんじ” from the cell.

2. Handling Cells with No Phonetic Text

If cell B1 contains the text “Hello” (which has no furigana or phonetic annotations), the formula:

=PHONETIC(B1)

This will return:

(empty string)

Since there are no phonetic characters, the result will be an empty string.

3. Working with Kanji and Phonetic Characters

If cell C1 contains the text “東京（とうきょう）” with kanji “東京” and furigana “とうきょう”, the formula:

=PHONETIC(C1)

This will return:

とうきょう

The PHONETIC function extracts the furigana “とうきょう” from the text.

Notes:

• Only Works with Text in Certain Languages: The PHONETIC function is most commonly used with Japanese text and phonetic annotations (furigana). It does not work with English or other languages that don’t use such annotations.
• IME Usage: Phonetic characters must be inserted via the Japanese Input Method Editor (IME) in Excel, and the PHONETIC function will only return the phonetic annotations (furigana) associated with the kanji or other characters.
• Empty Result: If no phonetic characters are present, the function returns an empty string, making it easy to check whether phonetic data exists in a cell.

Example Scenario:

When working with Japanese text in a document, if you need to extract only the phonetic pronunciation (furigana) from kanji characters, you can use the PHONETIC function to retrieve it for further processing, such as text-to-speech or linguistic analysis.

Related Functions:

• UNICODE: Returns the Unicode value of the first character in a text string. It can be helpful in conjunction with PHONETIC for understanding the underlying encoding.
• TEXT: For formatting numbers as text, though this does not handle phonetic characters like PHONETIC does.
• MID: Can be used for extracting a substring from a text, but unlike PHONETIC, it does not handle phonetic annotations directly.

The PHONETIC function is quite specialized and works mainly with East Asian text, especially Japanese, to extract pronunciation guides that accompany kanji characters.