How to use the Excel PHONETIC function

PHONETIC Function extracts the phonetic (furigana) characters from a text string.

Syntax: =PHONETIC(reference)

The PHONETIC function syntax has the following arguments:

  • reference (required). A string, or a reference to a cell or cell range containing a phonetic string. If a cell range is referenced, the phonetic string is returned in the upper-left cell of the range. If the range contains noncontiguous cells, the #NV error is returned.

Example: Let’s look at some Excel PHONETIC function examples and explore how to use the PHONETIC function as a worksheet function in Microsoft Excel:

The example may be easier to understand if you copy A1:C11 to a blank worksheet.

Add a Comment

Your email address will not be published. Required fields are marked *