PHONETIC function

This article describes the formula syntax and usage of the PHONETIC  function in Microsoft Excel.

Description

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

Syntax

PHONETIC(reference)

The PHONETIC function syntax has the following arguments:

  • Reference    Required. 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 " osaka ", the following are true:

=PHONETIC(C4) equals " tokyo "

=PHONETIC(B7) equals " osaka "



Was this information helpful?

How can we improve it?

How can we improve it?

To protect your privacy, please do not include contact information in your feedback. Review our privacy policy.

Thank you for your feedback!