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

Syntax

PHONETIC(reference)

Reference is a text string or a reference to a single cell or a range of cells that contain a furigana text string.

Remarks

Example

If cells C4 contains " tokyo tokyo tokyo" and cell B7 contains " osaka osaka osaka", the following are true:

=PHONETIC(C4) equals " tokyo tokyo tokyo tokyo tokyo tokyo"

=PHONETIC(B7) equals " osaka osaka osaka osaka osaka"

See also: