![www.mrexcel.com](https://www.mrexcel.com/board/styles/mrexcel/mrexcel-logo-og.png)
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...
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
困っているお婆さんを助けた。
これは著名なアーティストの作品だ。
このCDを借りてもいいですか。
Column B
困っている__を助けた。
これは著名な__の作品だ。
この__を借りてもいいですか。
Column C
お婆さん
アーティスト
CD
Many thanks