PHONETIC - Excel - Microsoft Office Online

Home > Products > Excel > Excel 2003 Help and How-to > Working with Data > Function Reference > Text and Data Functions

Warning: You are viewing this page with an unsupported Web browser. This Web site works best with Microsoft Internet Explorer 6.0 or later, Firefox 1.5, or Netscape Navigator 8.0 or later. Learn more about supported browsers.

Printer-Friendly Version

PHONETIC

Applies to: Microsoft Office Excel 2003

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 " 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 "