Coming a bit late, but it seems there is a PHONETIC() function in excel that converts to furigana. Needs to activate it by setting you regional setting to japanese (I could not find a way to make your macro work on a mac)