Create fill-in-the-blank Japanese sentences using Excel.

[Hamiie]

Create fill-in-the-blank sentences with xl

I need a macro that creates a series of fill-in-the-blank sentences or tests. The sentences without blanks are in column A. The sentences with blanks would appear in column B. The words to be blanked out in column B (replaced with an underscore line) are in column C. The rules to replace the...

www.mrexcel.com

Hi there,

The macro above works fantastic for English text, but I am unable to get this to work with Japanese text. I am hoping this macro may also be used for French text.

The desired output would look something like this.

Column A

困っているお婆さんを助けた。
これは著名なアーティストの作品だ。
このＣＤを借りてもいいですか。

Column B

困っている__を助けた。
これは著名な__の作品だ。
この__を借りてもいいですか。

Column C

お婆さん
アーティスト
ＣＤ

Many thanks

 

[Hamiie]

Extract kanji character from a cell in Excel

Hi, I am trying to find a formula/macro to extract kanji character only from a cell. For example: I want to remove Hiragana, Katakana from the Source sentence and display only Kanji characters in the Destination column. Thank you if anyone could help me. I often use the website Kanji...

www.mrexcel.com

Bumping this also, as this would be incredibly helpful.

Example:

Column A:

困っているお婆さんを助けた。
これは著名なアーティストの作品だ。
このＣＤを借りてもいいですか。

Column B (output):

困, 婆, 助
著, 名, 作, 品
借