Skip to main content

PHONETIC function

Description

PHONETIC Function extracts the phonetic (furigana) characters from a text string. To use the PHONETIC function, your region setting must be one of the Far East languages (Japanese, Chinese, and Korean).

Syntax

PHONETIC(reference)

Parameters

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.

Examples

Example 1

The example may be easier to understand if you copy the example data (include header) in the following table, and paste it in cell A1 of a new Excel worksheet. If you need to, you can adjust the column widths to see all the data.

Data Formula Result Description
さしすせそ =PHONETIC(A2) サシスセソ extracts the phonetic (furigana) characters from a text string.

Example 2: Combine the Contents of Multiple Cells

The example may be easier to understand if you copy the example data (include header) in the following table, and paste it in cell A1 of a new Excel worksheet. If you need to, you can adjust the column widths to see all the data.

Data Formula Result Description
Ex =PHONETIC(A2:A11) Excel Function joins text strings into one text string.
cel
#VALUE!
2022
TRUE
FALSE
=LEFT("Microsoft2021",3)
2014/11/11
14:33:15
Function

NOTE: PHONETIC function ignore error values, logical values, formula, date values, time values, and numbers, only text can be joined.

Leave a comment

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

Format your code: <pre><code class="language-vba">place your code here</code></pre>