PHONETIC

Microsoft Office Excel 2003

See Also

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

  • If reference is a range of cells, the furigana text string in the upper-left corner cell of the range is returned.
  • If the reference is a range of nonadjacent cells, the #N/A error value is returned.

Example

If cells C4 contains "TokyoTokyoTokyo" and cell B7 contains "OsakaOsakaOsaka", the following are true:

=PHONETIC(C4) equals "TokyoTokyoTokyoTokyoTokyoTokyo"

=PHONETIC(B7) equals "OsakaOsakaOsakaOsakaOsaka"