Split kanjis, words, phrases into different cells to make a Japanese vocabulary list

[Ceci]

Hi,

I am trying to
(1) separate a list of kanjis, Japanese words, Japanese phrases into a column list
(2) add a separate column the hiragana
(3) add a separate column for the English meaning so the list would be something like this

Challenge: some times there would be some words that consist of 1 kanji, 2 or 3 kanjis =words, words with hiragana and kanji

current list example in one line like this:
戦略実健康になる育つ

How it should be
1 戦略 せんりゃく　strategy
2 実 みのる　　　bear fruit
3 健康になる けんこう　getting healthy
4 育つ そだつ　　　to be raised

can any one help me how to do this on excel?

 

[Marc L]

Hi,​

​

as I am a very beginner in guessing so I may try to help with an accurate elaboration of the need​

and an attachment of the worksheet at 'before' state and another worksheet for the expected result …​