Excel formula translator
Translator
Functions
Translation table
Error codes
Academy
🔍
Search functions
🌐 EN ▾
English
Deutsch
Français
Español
Português
☰
Home
›
Functions
›
Text
›
PHONETIC
fx
PHONETIC
Text
· Since: Excel 2003 · 9 languages
Extracts the phonetic (furigana) characters from a text string.
🌐
Translations
English
PHONETIC
Deutsch
PHONETIC
Français
PHONETIQUE
Español
FONETICO
Italiano
FURIGANA
Português
FONÉTICA
Nederlands
FONETISCH
Polski
PHONETIC
Русский
PHONETIC
📦
Availability
Excel version
Available
Excel 2007
✓
Excel 2013
✓
Excel 2019
✓
Excel 2021
✓
Microsoft 365
✓
Translate a formula with this function
fx
EN
=PHONETIC(C4)
fx
DE
⌨
Syntax
PHONETIC(reference)
Arguments
reference
(required)
— Text string or a reference to a single cell or a range of cells that contain a furigana text string.
▶
Examples
=PHONETIC(C4)
=PHONETIC(B7)
Related functions
ARRAYTOTEXT
ASC
BAHTTEXT
CHAR
CLEAN
CODE
CONCAT
CONCATENATE
Copied to clipboard
↑
↓
·
Enter
·
Esc
Excel functions ›