The phonetic() function

[Jubinell]

Hi,

I'm not sure if anybody has ever heard of this function, but according to Microsoft:

Extracts the phonetic (furigana) characters from a text string.
Syntax
PHONETIC(reference)
Reference is a 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:
<code>=PHONETIC(C4)</code> equals トウキョウト"
<code>=PHONETIC(B7)</code> equals "オオサカフ"

http://office.microsoft.com/en-us/excel/HP052508411033.aspx

Well...I've tried these examples in my version of Excel 2007 but they return N/A errors. In fact, these formulas don't work for any other Kanjis either.

Any ideas?