Thursday, May 12, 2022

PHONETIC function [MS]

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

Note: To use the PHONETIC function, your region setting must be one of the Far East languages (Japanese, Chinese, and Korean). For more information, see Change regional format settings in Excel for the web.


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



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.


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


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"

No comments:

Post a Comment

Search This Blog

Customer ID column - Search Ads 360 Help [gg-searchads-en]

Customer ID column The ID Google Merchant center generated for an inventory account .   View this column Naviga...