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.