PHONETIC function

This article describes the formula syntax and usage of the PHONETIC function (function: A prewritten formula that takes a value or values, performs an operation, and returns a value or values. Use functions to simplify and shorten formulas on a worksheet, especially those that perform lengthy or complex calculations.) in Microsoft Excel.

Description

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

Syntax

PHONETIC(reference)

The PHONETIC function syntax has the following arguments (argument: A value that provides information to an action, an event, a method, a property, a function, or a procedure.):

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

 
 
Applies to:
Excel 2010, Excel Web App, SharePoint Online for enterprises, SharePoint Online for professionals and small businesses