PHONETIC function
This article describes the formula syntax and usage of the PHONETIC function in Microsoft Excel.
Description
Extracts the phonetic (furigana) characters from a text string.
Syntax
PHONETIC(reference)
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.
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 "
" and cell B7 contains "
", the following are true:
=PHONETIC(C4) equals "
"
=PHONETIC(B7) equals "
"
No comments:
Post a Comment