PHONETIC()

Syntax. PHONETIC(reference)

Definition. This function extracts the phonetic (Furigana) characters from a string.

Arguments

  • reference (required). A string, or a reference to a cell or cell range containing a phonetic string. If a cell range is referenced, the phonetic string is returned in the upper-left cell of the range. If the range contains noncontiguous cells, the #NV error is returned.

Background. The modern Japanese writing system uses three main scripts:

  • Kanji. Ideographs from Chinese characters

  • Kana. A pair of syllabaries, consisting of:

    • Hiragana, used for native Japanese words

    • Katakana, used for foreign words and names, loan words, onomatopoeia, scientific names, and sometimes to replace kanji or hiragana for emphasis

These fonts are ...

Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial