How to convert a column of Japanese words in a column of Hiragana words in Excel

[kanachan]

Hello!
I have a large column of Japanese words (some are entirely in hiragana, katakana or kanji, some are a mix of kanji and hiragana, some are a mix of kanji and katakana, and some a mix of hiragana and katakana), and I would like to convert that column of words into another column with exactly those same words but all of them written entirely in hiragana.

So for example, if in that first column there are words like this:

ゆっくり
ファッション
家族
落ち着く
アア溶岩

I would like to convert that into:

ゆっくり
ふぁっしょん
かぞく
おちつく
ああようがん

Looking for some information about it on Google, I've read that something can be done with VBA programming inside Excel, but I have no idea of programming and I couldn't understand barely anything.

Could you please help me to do this in Excel?

Thank you very much for all the help you can offer me.

 

[kanachan]

@John_w
Yes!! Now the macro works perfectly!
Let me thank you once again for all your assistance and your patience in helping me.

Thank you so much, John. I really appreciate a lot your help.