×
英语
很抱歉。本文没有你的语言版本。

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 " 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 "

扩展你的 Office 技能
了解培训
抢先获得新功能
加入 Office 预览体验计划

此信息是否有帮助?

谢谢您的反馈!

谢谢你的反馈! 可能需要转接到 Office 支持专员。

×