logo
excelfunctions.org
bookmarks

PHONETIC

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

TextText Processing

What it does

Extracts phonetic characters (furigana) from a text string (Japanese only).

Syntax

PHONETIC(reference)

Arguments

  • reference(reference) β€” Cell reference.

Examples

Get Furigana

Extract reading.

FORMULA
=PHONETIC(A1)
RESULT
(Katakana reading)
SAMPLE DATA
A
1Kanji
2(Japanese Text)